SQL Join (Nickname)

Question

Really stuck on this one: Fill in the blanks to select item names and names of customers who bought the items. Use custom names to shorten the statement.

SELECT ct.name, _.name
FROM customers_ct, items AS it
WHERE it.seller_id=_.id;

Answer 1

SELECT ct.name, it.name
FROM customers_ct, items AS it
WHERE it.seller_id=ct.id;

I assume those other lines represents whitespaces

Answer 2

# it, AS, ct

```sql
SELECT ct.name, it.name
FROM customers_ct AS ct, items AS it
WHERE it.seller_id = ct.id;

```