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.
Links:
https://coinmarketcap.com/
https://coinmarketcap.com/api/
https://www.microsoft.com/en-us/download/details.aspx?id=55994
https://www.w3schools.com/sql/default.asp
https://www.json.org/
SQL Query:
Json Importer:
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()
▶️ DTube
▶️ IPFS