answer please

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;

Answer 1

SQL course would help you.

select ct.name,
it.name --> custom name for item's table
from costumers AS ct, ----> assign custom name
join items as it on it.seller = ct.id
// the where clausule can help to filter the costumer or the item

Answer 2

Thanks

Answer 3

answer please

Indexing & Slicing

Conditions
Fill in the blanks to select all rows which have rank > 10 or type equal to 42:

df[(df['rank']>10) | (df[' ****** ']==42)]

what is for *******

Answer 4

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

ans
it
as
ct

Answer 5

it
As
ct

Answer 6

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

Answer 7

it
as
ct

Answer 8

it
as
ct

Answer 9

Fill in the blanks to select name and city from the ''people'' table.

Answer 10

Fill in the blanks to select the ''address'' from ''customers'', using the fully qualified name for the ''address'' column answerplease.

Answer 11

name
people

Answer 12

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

ans
it
as
ct

Answer 13

Fill in the blanks to select name and city from the ''people'' table.

Answer 14

SELECT id, name

FROM students WHERE id
12;