Question

2. Write SQI commands for the following statements:
(a)
Raj is a database programmer, He has to write the query from EMPLOYEE table to search
for the employee whose name begins from letter "R"
(b) Suppose a table BOOK contain columns (BNO, BNAME, AUTHOR, PUBLISHER),
Raj is assigned a task to see the list of unique publishers, write the query to fetch unique
publisher names from table.
(C) Raj is a database programmer, He has to write the query from EMPLOYEE table to
search for the employee who are not getting any commission,
(3 Points)​

Answer 1

very easy!!

Explanation:

a) Select distinct names from employee where names like 'R%'

b) select distinct publisher from Book

c) select * from Employee where comission is null

You can reach out to me if want to master in SQL.

Cheers!!