LU05.S01 - SQL-DQL: Select from one table

Create a address-list of the customers with the columns in this order: CustomerName, Address, PostalCode, Country, ordered by the the Country ascending.

Select CustomerName, Address, PostalCode, Country
from customers
order by country;

Generate a list with ProductNames, Price and SupplierIDs within a price range of 20 and 45, sorted the Price and SupplierID, both ascending.

SELECT Price, Productname,  Supplierid FROM Products 
WHERE Price BETWEEN 20 AND 45
ORDER BY Price ASC, SupplierID ASC;

Find all employees who graduated from a university. The relevant information is hidden in the table Employees, within the colums Notes.

SELECT * FROM Employees 
WHERE Notes LIKE "%grad%"; 

Volkan Demir