Questions
Questions

IDBF001 Tutorial Quiz 8 |LA008 - Requires Respondus LockDown Browser

Multiple dropdown selections

Candy Database    Candy  ( CandyType char(15), Cost dec(9,2), Colour char(10))                                     People ( PersonName char(20), Age smallint,                                                   Suburb char(20),   PhoneNumber char(10))                                     Likes    ( PersonName char(20), CandyType char(15))   Use the drop down lists to re-write the following query as a INNER JOIN. Select C.CandyType, Cost, PersonName From Candy C, Likes L Where C.CandyType = L.CandyType     And PersonName like '%Peter%'     Select C.CandyType, Cost, PersonName [ Select ] From Candy C INNER JOIN Likes L L Likes INNER JOIN C Candy From Candy C INNER JOIN Likes L INNER JOIN People P [ Select ] On C.CandyType = L.CandyType On C.CandyType = P.PersonName Where C.CandyType = L.CandyType [ Select ] Where PersonName like '%Peter%' And PersonName like '%Peter%' Having P.PersonName like '%Peter%'

View Explanation

View Explanation

Verified Answer
Please login to view
Step-by-Step Analysis
First, let's restate what the question is asking and what the provided answer options represent. - The task is to rewrite the given query using INNER JOIN syntax by selecting the appropriate dropdown pieces. - The original query is: Select C.CandyType, Cost, PersonName From Candy C, Likes L Where C.CandyType = L.CandyType And PersonName like '%Peter%'. - The provided answer array (the selections for the dropdowns) is: 1) From Candy C INNER JOIN Likes L 2) On C.CandyType = L.CandyType 3) Where PersonName like '%Peter%' Option analysis: - Option 1: 'From Candy C INNER JOIN Likes L' This cho......Login to view full explanation

Log in for full answers

We've collected over 50,000 authentic exam questions and detailed explanations from around the globe. Log in now and get instant access to the answers!

Similar Questions

Two tables may be joined:

Question at position 51 We can calculate the cumulative sum for each date using the following SQL statement: SELECT t1.date, t1.precip AS 'daily precip', SUM(t2.precip) AS 'cum. precip' FROM rainfall AS t1 INNER JOIN rainfall AS t2 ON t2.date >= t1.date GROUP BY t1.date ORDER BY t1.date;TrueFalse

Question at position 57 We can calculate the cumulative sum for each date using the following SQL statement: SELECT t1.date, t1.precip AS 'daily precip', SUM(t2.precip) AS 'cum. precip' FROM rainfall AS t1 INNER JOIN rainfall AS t2 ON t2.date >= t1.date GROUP BY t1.date ORDER BY t1.date;TrueFalse

Question at position 57 We can calculate the cumulative sum for each date using the following SQL statement: SELECT t1.date, t1.precip AS 'daily precip', SUM(t2.precip) AS 'cum. precip' FROM rainfall AS t1 INNER JOIN rainfall AS t2 ON t2.date >= t1.date GROUP BY t1.date ORDER BY t1.date;TrueFalse

More Practical Tools for Students Powered by AI Study Helper

Join us and instantly unlock extensive past papers & exclusive solutions to get a head start on your studies!