Your question is Join Tables and Return Matches. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Microsoft wants a clean list of Surface products currently available for sale. Write a PostgreSQL query that returns the product records matching the required product line and availability criteria.
product_line is Surface and availability is Available.| Column | Type | Description |
|---|---|---|
| product_idPK | INTEGER | Unique product identifier |
| product_name | VARCHAR(100) | Product display name |
| product_line | VARCHAR(50) | Microsoft product family |
| availability | VARCHAR(30) | Current sales availability |
| list_price | NUMERIC(10,2) | Product price in US dollars |