#3 Meesho SQL Hackerank Question | Crypto
Автор: Corpverse
Загружено: 2025-12-26
Просмотров: 95
Описание:
-- Create coins table with unit_value as VARCHAR to store "$"
CREATE TABLE coins (
coin_name VARCHAR(50),
quantity INT,
unit_value VARCHAR(20) -- e.g., "$60,000"
);
-- Create tokens table with unit_value as VARCHAR
CREATE TABLE tokens (
token_name VARCHAR(50),
quantity INT,
unit_value VARCHAR(20)
);
-- Insert sample data into coins
INSERT INTO coins (coin_name, quantity, unit_value) VALUES
('BTC', 2, '$60,000'),
('ETH', 10, '$3,500'),
('BNB', 15, '$400'),
('SOL', 100, '$150'),
('ADA', 2000, '$1.20'),
('XRP', 3000, '$0.80'),
('DOT', 500, '$25'),
('AVAX', 300, '$30'),
('LTC', 50, '$150'),
('DOGE', 10000, '$0.20');
-- Insert sample data into tokens
INSERT INTO tokens (token_name, quantity, unit_value) VALUES
('USDT', 5000, '$1.00'),
('LINK', 400, '$35'),
('UNI', 600, '$20'),
('MATIC', 1000, '$1.50'),
('SHIB', 1000000, '$0.00001'),
('AAVE', 50, '$300'),
('COMP', 30, '$350'),
('SUSHI', 1000, '$8'),
('SNX', 800, '$10'),
('CRV', 1200, '$3');
Connect with us here : https://topmate.io/corpverse
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: