Simpsons Quality 2010

Some queries on the database greenhouse

Customers whose name is 'Alfonso'.
Solution:

SELECT * FROM CUSTOMERS WHERE NAME = 'Alfonso'

customers whose name begins with 'A'.
Solution:
SELECT * FROM CUSTOMERS WHERE NAME LIKE 'A *'
Customers
sorted by last name.
Solution:
SELECT * FROM CUSTOMERS ORDER BY SURNAME

Name of customers who are delinquent.
Solution:
SELECT Name, Surname FROM WHERE PAYING CUSTOMERS = True