HomeworkLib
Question

What is wrong with the following SQL statement? select first_name , last_name , phone from Customer,...

What is wrong with the following SQL statement?

select first_name
     , last_name
     , phone
from Customer, Orders
where customer.customerid = orders.customerid;

Group of answer choices

1 You cannot join customer.customerid to orders.cutomerid

2 Nothing is wrong with this statement.

3 The join is wrong. You can only join tables in the FROM clause.

4 The result will be a Cartesian Product.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1 
Given sql statement has no syntax errors.


2 Nothing is wrong with this statement.
0 0
Add a comment
Know the answer?
Add Answer to:
What is wrong with the following SQL statement? select first_name , last_name , phone from Customer,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Express the following SQL command in English: SELECT last_name, first_name                 FROM students             &

    Express the following SQL command in English: SELECT last_name, first_name                 FROM students                 WHERE first_name LIKE 'D%' OR last_name LIKE '%n';

  • How would I write the SQL statement SELECT fname AS First_Name, lname AS Last_Name FROM employee...

    How would I write the SQL statement SELECT fname AS First_Name, lname AS Last_Name FROM employee WHERE salary BETWEEN 10000 AND 30000; in relational algebraic syntax?

  • what is wrong with this database says inner is not a table SELECT last_name, first_name, job_title,...

    what is wrong with this database says inner is not a table SELECT last_name, first_name, job_title, salary, min_salary, max_salary, city, state_province, country_name FROM employees INNER JOIN jobs ON employees.job_id = jobs.job_id, INNER JOIN departments dep ON employees.department_id = dep.department_id INNER JOIN locations ON dep.locations_id = locations.location_id INNER JOIN countries ON locations.country_id = countries.country_id WHERE dep.location_id = 1700 ORDER BY salary DESC;

  • SQL From employees table, display the first_name, last_name, phone_number and Phone number Type. ...

    SQL From employees table, display the first_name, last_name, phone_number and Phone number Type. Phone number type should be "USA Phone Number" (Length=12) or "International Phone Number" (Length=18) or "Unknown" based on the length of the phone number. Sort the display in desc order of phone number type Use Either CASE or DECODE. Output Column Heading: First Name, Last Name, Phone Number, Phone Number Type

  • SQL From employees table, display the first_name, last_name, phone_number and Phone number Type. Phone number type...

    SQL From employees table, display the first_name, last_name, phone_number and Phone number Type. Phone number type should be "USA Phone Number" (Length=12) or "International Phone Number" (Length=18) or "Unknown" based on the length of the phone number. Sort the display in desc order of phone number type Use Either CASE or DECODE. Output Column Heading: First Name, Last Name, Phone Number, Phone Number Type

  • What is wrong with the following query? select firstname , lastname from Customer intersect select productid...

    What is wrong with the following query? select firstname , lastname from Customer intersect select productid , price , quantity from order_detail join orders on order_detail.orderid = orders.orderid; Group of answer choices 1 Nothing is wrong with this query 2 When working with set operators both queries have to contain the same number of columns. 3 The wrong set operator is being used. This query should use EXCEPT. 4 The wrong set operator is being used. This query should use...

  • rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name...

    rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name varchar(25) student last name major_id integer the ID of the student's major; a foreign key for the major_id in the rider_major table rider_major Column Data Type Description major_id integer the primary key major_name varchar(50) student first name major_description varchar(100) student last name Use the Tables above to answer the questions. Questions: 1. Write a SQL statement to add a student record to the rider_student...

  • 1) Write or select the correct SQL statement that satisfies the following case: Change record with...

    1) Write or select the correct SQL statement that satisfies the following case: Change record with value 'Nick' to 'Cuba' for the 'Last Name' attribute in the table 'Vendors' A. UPDATE VENDORS SET LAST_NAME='CUBA' WHERE LAST_NAME=NICK B.INSERT INTO LAST_NAME VALUES("NICK"); C.INSERT INTO 'NICK' VALUES('VENDORS'); D. INSERT INTO VENDORS WHERE LAST_NAME="NICK" 2) Write or select the correct SQL statement that satisfies the following case: Change record with value 'Gary' to 'Jada' for the 'Style' attribute in the table 'Invoice_Line' A. INSERT...

  • (TCO 7) Write a JOIN to display the instructor first and last names and the course...

    (TCO 7) Write a JOIN to display the instructor first and last names and the course description for the course the instructor is teaching Student Instructor Zipcode PK Student ID PK Instructor ID PK Zip Salutation First Name Last Name Street Address Phone Employer Registration Date Salutation First_Name Last_Name Street Address City State FK1 Zip FK1 Zip Section PK Section ID Course Course Section_Num Enrollment Start Date_Time Location PK Course ID PK,FK1 Section ID PK,FK2 Student ID Capacity FKI |...

  • 1. Select the correctly written query. SELECT ALL FROM CUSTOMERS WHERE 10243 IS CUSTOMERID PULL *...

    1. Select the correctly written query. SELECT ALL FROM CUSTOMERS WHERE 10243 IS CUSTOMERID PULL * FROM CUSTOMERS WHERE CUSTOMERID = 10243 GET LIST FROM CUSTOMERS SELECT * FROM CUSTOMERS WHERE CUSTOMERID = 10243 2. The GROUP BY clause can be used in place of a JOIN clause in a SQL query? True False 3. The number of join conditions is always equal to the number of tables being joined _____ one. Plus Divided by Times Minus

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT