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
Congratulations @cryptostein! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on the badge to view your Board of Honor.
If you no longer want to receive notifications, reply to this comment with the word
STOPDo not miss the last post from @steemitboard!
Participate in the SteemitBoard World Cup Contest!
Collect World Cup badges and win free SBD
Support the Gold Sponsors of the contest: @good-karma and @lukestokes
Congratulations @cryptostein! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :
Click on the badge to view your Board of Honor.
If you no longer want to receive notifications, reply to this comment with the word
STOPDo not miss the last post from @steemitboard:
Congratulations @cryptostein! You received a personal award!
Click here to view your Board of Honor
Congratulations @cryptostein! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Vote for @Steemitboard as a witness to get one more award and increased upvotes!