SQL Queries

use sql_store;

select * from customers;

select * from orders;

select *

from customers as c

inner join orders as o

on c.customer_id=o.customer_id;

select *

from customers as c

inner join orders as o

on c.customer_id=o.customer_id

order by c.customer_id;

select *

from customers as c

inner join orders as o

using(customer_id);

select customer_id,order_id,status

from customers as c

inner join orders as o

using(customer_id);

select customer_id,order_id,status

from customers as c

inner join orders as o

using(customer_id)

order by customer_id;