SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
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 null, customer_id int references Customers(customer_id), product_name varchar(50) null, quantity int null check (quantity > 0), price decimal(7, 2) null ); 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 * from Sales; 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;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear