Dec 14, 2022·1 reply
BIGGWAVEokay so when you use commands to fetch data you use it on the server right?
Idk what you mean by commands to fetch, there isn't a SQL CLI. The app you use, say MSSQL, will have UI you can use to connect to a server, you'll just need to enter a server name and password if that's required
- OPDec 14, 2022·1 reply
BVLSELECT Products.ProductID,
AVG(OrderDetails.UnitPrice (1 - DISCOUNT) ) AS AveragePriceReceived,
Products.UnitPrice,
(AVG(OrderDetails.UnitPrice (1 - Discount) ) - Products.UnitPrice) /
AVG(OrderDetails.UnitPrice * (1 - Discount) ) AS PercentPriceDifference
FROM OrderDetails
INNER JOIN
OrderHeaders ON OrderDetails.OrderID = OrderHeaders.OrderID
INNER JOIN
Products ON Products.ProductID = OrderDetails.ProductID
WHERE OrderHeaders.OrderDate BETWEEN '2019-01-01' AND '2019-12-31'
GROUP BY Products.ProductID;this what they got u doin at work bvl?
- OPDec 14, 2022·1 replyYuzzy
Idk what you mean by commands to fetch, there isn't a SQL CLI. The app you use, say MSSQL, will have UI you can use to connect to a server, you'll just need to enter a server name and password if that's required
but isnt what bvl just posted commands to view data?
thats what i meant 
ruckus ⌀Dec 14, 2022·1 replyoutsource the work
- Dec 14, 2022·2 repliesBIGGWAVE
this what they got u doin at work bvl?
nah I just actually had a project using SQL this semester. Just posting my work from it
- OPDec 14, 2022·1 replyruckus
outsource the work
imma pay them 2 dollars an hour - OPDec 14, 2022·1 replyBVL
nah I just actually had a project using SQL this semester. Just posting my work from it
so what you wrote was you searching product units and s*** right?
- ruckus ⌀Dec 14, 2022·1 replyBIGGWAVE
imma pay them 2 dollars an hourhas your work given you server credentials for their sql database?
- OPDec 14, 2022·1 replyruckus
has your work given you server credentials for their sql database?
what tf is server credentials?
- ruckus ⌀Dec 14, 2022·1 replyBIGGWAVE
what tf is server credentials?
ip
username
password - Dec 14, 2022·1 replyBIGGWAVE
so what you wrote was you searching product units and s*** right?
- OPDec 14, 2022·1 replyruckus
ip
username
passwordyes
- ruckus ⌀Dec 14, 2022·1 replyBIGGWAVE
yes
its over.
- OPDec 14, 2022ruckus
its over.
im leading the team too - OPDec 14, 2022·2 repliesBVL
u memorized this s***?
- Dec 14, 2022·1 replyBIGGWAVE
u memorized this s***?
nah I just copy and pasted
its 2022
- OPDec 14, 2022·2 repliesBVL
nah I just copy and pasted
its 2022
i wish there was a website i can get the commands for s***
- Dec 14, 2022BIGGWAVE
but isnt what bvl just posted commands to view data?
thats what i meantAh yes
SQL is unique in that its language is based on certain keywords, one being select. Select * from table_name is how you see a table 
Dec 14, 2022BIGGWAVEu memorized this s***?
It’s easy if you know the data structure. SQL syntax is very simple.
- Dec 14, 2022·2 repliesBIGGWAVE
i wish there was a website i can get the commands for s***
i got you
- Dec 14, 2022·1 replyBIGGWAVE
i wish there was a website i can get the commands for s***
There is, Google.com
- OPDec 14, 2022BVL
i got you
https://www.w3schools.com/sql/
thanks alot fam
- Dec 14, 2022
I will never understand not using search engines 
Dec 14, 2022·1 reply- OPDec 14, 2022BVL
i got you
https://www.w3schools.com/sql/
this is so fire bruh
u saved my life