Question

write an SQL SELECT statement for retrieve the name and income of customers without charges in january 2020

Answer 1

Assuming that the relational table Employee condists of following attributes:

Name, Income, payMonth, payYear

Note, since attributes not mentioned in the question and the question focusses on SELECT SQL statement, to avoid any confusion, the income attribute here can be itself taken as the income without charges which is maintained in a relation on a monthly as well as yearly basis.

The final SQL statement is:

• SELECT Name, Income
• FROM Employee
• WHERE payMonth = 'January' and payYear = 2020 ;