题目
题目

IDBF001 Tutorial Quiz 8 |LA008 - Requires Respondus LockDown Browser

多重下拉选择题

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%'

查看解析

查看解析

标准答案
Please login to view
思路分析
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

登录即可查看完整答案

我们收录了全球超50000道考试原题与详细解析,现在登录,立即获得答案。

类似问题

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

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！