Fill in the blanks to select item names and names of customers who bought the items.

Question

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;

//What is the answer of this three blank spaces. Please reply the answer of this question .

Answer 1

SELECT ct.name, [[it]].name
FROM customers [[AS]] ct, items AS it
WHERE it.seller_id= [[ct]].id;

I don't think that makes sense unless your customers sell stuff to themselves.

Answer 2

it
as
ct

Answer 3

1) items 2)table 3) ct
I'm still learning SQL

Answer 4

But it shows wrong when I checked answer

Answer 5

1) items 2) AS 3) ct

Answer 6

No question is true and it is the practice question in my sql

Answer 7

Mam

Answer 8

The SQL is correct, but it's weird to compare the item's seller id to the customer's id. That implies that the customer (who probably bought something) is the seller.

Answer 9

Ya mam you are right

Answer 10

Answer is >=.

Answer 11

answer is
it
as
ct

Answer 12

SELECT ct.name,
it
.name

FROM customers
as
ct, items AS it

WHERE it.seller_id=
ct
.id;

Answer 13

it, as, ct

Answer 14

select
from