help me out

select KNOWLEDGE from ktt2 where sxn = LIFE

help bro

What are you even asking for

lol

what sql program can i learn quickly that many offices use

Program to do what?
Do you mean a dialect of SQL? If so, I'd rec T-SQL but they're all generally same down to syntax

SQL is a language for databases

Wants to learn SQL, but can't do a basic Google search?

shambles off rip it's not looking too good but i have faith in him

can you name me a common program that many offices use that use sql language?

Microsoft SQL Server

Yeah, at least he's trying

Postgres, MSSQL, or Oracle

so people would enter commands to fetch data and you can also enter data in it also?

ahhh yes thanks fam

have u got experience with microsoft access/excel

yea i do
would you consider excel a form of sql or no?

no

it’s a bit different like

you’re entering data directly into a file with access/excel unless you use SQLite it does not behave the same

honestly without knowing ur end goal it’s kinda hard to recommend what to do imo

You can upload data from your machine onto SQL
You can connect to a server and read data from there

You can write SQL programs but generally you'll use it for quick and dirty queries, acquiring information about data

okay so when you use commands to fetch data you use it on the server right?

you send a request to a server and receive data from it, generally

SELECT 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;