q1
select p.product_id,p.product_finish
from product p;

q2
select p.product_id,p.product_finish
from product p
group by product_line_id
order by product_line_id asc;

q3
select p.product_id,p.product_finish
from product p
group by product_line_id
order by product_line_id desc;

q4
select p.product_line_id,count(*)as total
from product p
group by p.product_line_id;

q5
select p.product_id,p.product_description
from product p
where product_description like'%table%';

q7
SELECT o.order_date
from ordert o
order by order_date;

q8
select c.customer_name,o.order_id
from customer c,ordert o
where o.customer_id =c.customer_id;

q9
select c.customer_name,c.customer_id,c.customer_address,c.customer_city,c.customer_state,
c.zip,o.order_id,o.order_date,r.ordered_quantity,p.product_description,p.standard_price
from customer c,ordert o,order_line r,product p
where c.customer_id =o.customer_id and o.order_id = r.order_id and r.product_id=p.product_id
and o.order_id=106;

q10
select distinct (c.customer_id)
from customer c,ordert o
where o.order_id in(
select o.order_id
from ordert o
where c.customer_id=o.customer_id);