Untitled

 avatar
unknown
sql
4 months ago
843 B
5
Indexable
Create TABLE Employees (
	Department varchar(50),
	FirstName varchar(10),
	LastName varchar(10),
)

Create TABLE Products (
	ProductID varchar(20),
	ProductName varchar(20),
	Category varchar(20),
	Price varchar(20),
)

Create TABLE Customers (
	CustomerID varchar(20),
	CustomerName varchar(20),
	City varchar(20),
	Country varchar(20),

)

SELECT DISTINCT Department FROM Employees;

SELECT DISTINCT	FirstName, LastName FROM Employees;

SELECT	ProductID, ProductName, Category, Price
FROM Products ORDER BY Price ASC;

SELECT ProductID, ProductName, Category, Price FROM Products
ORDER BY Category ASC, Price DESC;


SELECT CustomerID, CustomerName, City, Country
FROM Customers
WHERE CustomerName LIKE 'A%';

SELECT CustomerID, CustomerName, City, Country
FROM Customers
WHERE CustomerName LIKE '%son%'
Editor is loading...
Leave a Comment