Write the following queries in the algebraic form using relational and theoretical operators: (Use 3 steps) SELECT Serial_no, COUNT(*), AVG(Sale_Price) FROM SALE GROUP BY Serial_no HAVING...

Write the following queries in the algebraic form using relational and theoretical operators:

(Use 3 steps)

SELECT Serial_no, COUNT(*), AVG(Sale_Price) FROM SALE

GROUP BY Serial_no HAVING AVG(Sale_Price) <>

AND COUNT(*) > 2 OR COUNT(*)=1;