Database Systems

Given the following relation schemas:

CAR = (serialN, model, advertisedPrice)

SALES = (salespersonID, serialN, date, salesPrice)

SALESPERSONS = (salespersonID, Name, Address)

Express the following by SQL statement

1) List the name and ID of every salesperson who sold at least two cars with salesprice greater than $10000.

2) List all attribute of unsold car with advertisedPrice greater $20000 (i.e all attributes of the table CAR).