Challenge SQL JOIN A sql-6-4.sql file has been opened for you. Write each of the

Question

Challenge SQL JOIN A sql-6-4.sql file has been opened for you. Write each of the following tasks as a SQL statement in a new line (remember that you can source the file to compare the output reference): 1. Use the e store database 2. Write a SELECT JOIN query that displays the following table I id I product_name | price I stars | 1 3 1 PC l 157.40 3 l Headphones l 20.00 I 1 4 I Headphones 20.001 2 I 5I 3 rows in set (0.02 sec) Once you have completed these tasks press the Check It! button to have your solution assessed.

Explanation / Answer

The syntax goes like this

SELECT column names (The column names should give as table_name.column_name)

FROM table_name1

INNER_JOIN table_name2 common_column_in_both_tables

P:S: try to give the db next time to explain more clearly

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.