Consider the Branches table as follows.

branchNo	street	city	postcode	employees
B005 B007 B003 B004 B002	22 Deer Rd 189 Hudson St 81 Stepford Dr 250 Fifth Ave 56 Clover St	London New York Glasgow New York London	SW14EH 10013 G119QX 10001 NW16EU	18 22 12 32 26

Write the SQL statement that lists all the attributes of the New York branch with more than 30 employees.

Output screenshot:

Write the SQL statement that lists the branchNo, the street, the city, and the employees of branches with number of employees between 18 and 30.

Output screenshot:

Write the SQL statement that lists the branchNo, the street, and the city of branches located in addresses ending with St.

Output screenshot: