Question

Using the table SALE of CARSHOWROOM database, write SQL queries for the following:

1. Display the InvoiceNo and commission value rounded off to zero decimal places.
2. Display the details of SALE where payment mode is credit card..

Answer 1

a)

SELECT InvoiceNo, ROUND(Commission, 0) AS RoundedCommission 
FROM SALE;

b) 

SELECT * 
FROM SALE 
WHERE PaymentMode = 'Credit Card';