answer please | Sololearn: Learn to code for FREE!

+4

answer please

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;

7/9/2017 5:40:09 PM

Tirth Luhar

12 Answers

New Answer

+4

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

+3

Thanks

+1

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

+1

+1

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

+1

+1

+1

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

0

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

-1

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

-1

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 *******

-1

SELECT id, name FROM students WHERE id 12;