Good Day Ladies and Gentlemen, this is my first video ever , I was a little nervous, buy still persevered . Wanted to edit the video to remove mistakes, but decided to leave them, as mistakes is part of life and only by failing and standing back up will we learn.
SELECT JSONDATA.* into CoinMarketCap FROM OPENROWSET (BULK 'C:\Cryptostein\CoinMarketCap.json', SINGLE_CLOB) as j CROSS APPLY OPENJSON(BulkColumn) WITH( id nvarchar(100), name nvarchar(100), symbol nvarchar(100),[rank] float, price_usd float, price_btc float,[24h_volume_usd] float,market_cap_usd float,available_supply float,total_supply float, max_supply float,percent_change_1h float ,percent_change_24h float,percent_change_7d float,last_updated nvarchar(100)) AS JSONDATA
SQL Query Examples:
--Select All Coins from Table Select * from CoinMarketCap --Select All Coins where Price below X price Select * from CoinMarketCap where price_usd > 0.10 and price_usd < 1 order by price_usd asc --Select Top 10 Coins where Circulating Supply below 5 500 000 Select Top 10 * from CoinMarketCap where available_supply < 5500000 order by price_usd asc --Select a Random Coin Select top 1 * from CoinMarketCap order by newid() --Select Random Coin with specific where clause Select top 1 * from CoinMarketCap where rank > 100 order by newid()