Skip to content
The Chat Archive
gpt-3.5-turbo-0301· OpenAI WildChat-4.8M (AI2)

7. Question 7 What does the following query return? SELECT * FROM employees RIGHT JOIN…

  1. User

    Question 7 What does the following query return?

    SELECT *

    FROM employees

    RIGHT JOIN machines ON employees.device_id = machines.device_id;

    1 point

    All columns of the employees and machines table and the records from employees and machines that match on device_id

    All columns and records from the employees and machines tables

    All columns of the employees and machines table, all records from the machines table, and the records from employees that match on device_id

    All columns of the employees and machines table, all records from the employees table, and the records from machines that match on device_id

  2. Assistant

    All columns of the employees and machines table, all records from the machines table, and the records from employees that match on device_id

  3. User

    Question 8 You are working with the Chinook database. You want to return the lastname and title columns from the employees table. Replace --??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)

    12 --??? FROM employees; Reset What is the title of the employee with the last name of Callahan?

    1 point

    IT Staff

    IT Manager

    General Manager

    Sales Manager

  4. Assistant

    IT Manager

  5. User

    Question 9 You are working with the Chinook database and are responsible for filtering for invoices with a total that is more than 20. Replace --??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)

    123 SELECT customerid, total FROM invoices --??? Reset How many invoices have a total that is more than 20?

    1 point

    2

    1

    4

    3

  6. Assistant

    4