SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
drop table Sales; drop table Customers; CREATE TABLE Customers( customer_id int PRIMARY KEY NOT NULL, first_name varchar(50) NULL, last_name varchar(50) NULL, city varchar(50) NULL ) ; CREATE TABLE Sales ( sales_id INT PRIMARY KEY NOT NULL, sales_date DATE, customer_id INT REFERENCES Customers (customer_id), product_name VARCHAR (50), quantity INT CHECK (quantity > 0), price DECIMAL (7, 2) ); insert into Customers values(1,'marco','rossi','milan'); insert into Customers values(2,'john','doe','london'); insert into Customers values(3,'mark','smith','liverpool'); insert into Customers values(4,'mary','jane','london'); insert into Sales values(1,'2018-09-01',1,'xyz',5,1.5); insert into Sales values(2,'2018-09-01',2,'abc',2,2); insert into Sales values(3,'2018-09-02',3,'xyz',10,1.5); insert into Sales values(4,'2018-09-02',4,'abc',4,2); insert into Sales values(5,'2018-09-03',1,'abc',2,2.2); insert into Sales values(6,'2018-09-03',2,'xyz',3,1.5); select * from Customers; select last_name,city from Customers; select s.*, s.price * s.quantity as amount from Sales s; select distinct city from Customers; select DISTINCT YEAR(sales_date), customer_id from Sales; select TRIM(last_name) from Customers; select * from Customers WHERE city = 'milan' or city = 'liverpool'; select * from Sales where product_name ='xyz' and quantity > 5; select *, case when city='milan' then 'Italy' when city IN ('liverpool','london') then 'UK' else 'N/A' END as Country from Customers
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear