Question

Using the table SALE
of CARSHOWROOM
database, write
SQL queries for the
following:
a) Display the InvoiceNo
and commission
value rounded off to
zero decimal places.
b) Display the details of
SALE where payment
mode is credit card..

Answer 1

Answer: the following is the solution to the question

a)

SELECT InvoiceNo, ROUND(commission,0)

FROM SALE;

b)

SELECT * FROM SALE Where Payment mode= credit card;