Choose the SQL statement that has no syntax error and is valid.a. SELECT Student level, AVG (marks) average_markofFROM StudentsWHERE Student level = 'BTECH'stionGROUP BY Student levelHAVING AVG (marks) > 55;b. SELECT Student level, AVG (marks) average_markFROM StudentsWHERE Student level = 'BTECH'HAVING AVG (marks) > 55GROUP BY Student level;O C. SELECT Student level, AVG(marks) average_markFROM StudentsWHERE Student level = 'BTECH'GROUP BY Student levelHAVING average_mark > 55;O d. SELECT Student level, AVG (marks)average_markFROM StudentsWHERE AVG (marks) > 55HAVING Student level = 'BTECH'GROUP BY Student_level;ae here to searchDELL

Option C is the correct and valid Answer SELECT Student_level, AVG(marks)average_mark FROM…

Answered: C. SELECT Student level,…

C. SELECT Student level, AVG(marks)average_mark FROM Students WHERE Student level = 'BTECH' %3D GROUP BY Student level HAVING average mark > 55;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 19MC

See similar textbooks

Similar questions

How is the processing of SQL DDL statements (such as CREATE TABLE) different from the processing required by DML statements?
QuestionsWrite SQL statements that will answer the following four questions based onthe following tables.1. Find suppliers (company name, country and city) whose country isAustralia or whose city is Paris.2. Compute the extended price for each order. Extended price is obtained bymultiplying unit price by quantity (from Order Details table). Show order id,product name and extended price. Sort the results by product name inascending order.3. List products ids and product names of discontinued confection productsthat are still held in stock. (Confection products are those that have"Confections" as category name.)4. Find the total quantity of each product ordered within each category.Display the category id, category name, product name and total quantity. Hints:The MONTH(DateField) function can be used to evaluate criteria about the month portion of adate field.The FORMAT(DateField) function can be used to return the month names.The SELECT statement has several options that can be used…
Answer number 10,12 and 13 Write the SQL statement to generate the report the following 1. Generate a report for all employees in Ascending order 2. Generate a report for all employees in Descending order 3. Generate a report for all employees in Ascending order with their assigned offices 4. Generate a report for all employees in Descending order with their assigned offices 5. Generate a report on customers 6. Generate a report on all customers and assigned sales reps 7. List all payments within a specified time frame of your choice 8. List all the sum total of all products orders. 9. Fetch the highest paying customer. 10. Fetch the highest paying employee 11. Fetch the highest paying product 12. Fetch all orders with complaints 13. Create a report on the total profits of the following offices a. NYC b. London c. Paris d. Tokyo 14. Fetch the lowest paying customer. 15. Fetch the lowest paying employee 16. Fetch the lowest paying product
Write the SQL statement that will list the city and state of all customers. If more than one customer is from the same city and state, only list that city and state once. Sort the output by state and then by city.
A valid SQL statement should be accepted by a standard SQL interpreter, whereas an invalid SQL statement should result in an error message. Indicate for each of the following SQL statement, whether it is a valid SQL statement or NOT a valid SQL statement. 1. SELECT * FROM ARTICLES WHERE ENDPAGE-STARTPAGE>8;2. SELECT * FROM ARTICLES WHERE ENDPAGE-STARTPAGE<0;3. SELECT SUM (TITLE) FROM ARTICLES;4. SELECT AVG(YEAR) FROM ARTICLES WHERE TITLE LIKE ‘M%’;5. SELECT COUNT(*) FROM ARTICLES GROUP BY YEAR;6. SELECT YEAR, COUNT(*) FROM ARTICLES WHERE COUNT(*)>10 GROUP BY YEAR;
Write a Structured Query Language (SQL) statement for each of the following questions: a) For the appointment with ApptNo ‘A1008’, postpone the ApptDate to a week later. b) Pholdee has quitted his job as massage therapist from the centre, his TheraID is ‘TH211311’.Clear his record from the table. Assume that there is no related child record. c) Calculate the total sales gained from all the services where their serviceDesc prefix is ‘FOOT’.Give a suitable Alias for the column selected.
51. The given SQL statement is intended to either (1) list the customer numbers, customers names, and headquarter cities of customers headquartered in Los Angeles or (2) satisfy the two conditions of having a customer number higher than 1000 and being headquartered in Denver. SELECT CUSTNUM, CUSTNAME, HQCITY FROM CUSTOMER WHERE HQCITY= 'Los Angeles" Which set of lines should be added to the end of the statement to make the statement work as intended? A: (CUSTNUM>1000 AND HQCITY-'Denver'); B: AND (CUSTNUM>1000 AND HQCITY='Denver*); C:OR CUSTNUM>1000 OR HQCITY='Denver": D:OR (CUSTNUM> 1000 AND HQCITY='Denver*);
can you help me iwth these two queries in mySQL. Write a SQL statement to create a table job_history including columns employee_id, start_date, end_date, job_id and department_id and make sure that, the employee_id column does not contain any duplicate value at the time of insertion and the foreign key column job_id contain only those values which are exists in the jobs table. Write a SQL statement to create a table employees including columns employee_id, first_name, last_name, email, phone_number hire_date, job_id, salary, commission, manager_id and department_id and make sure that, the employee_id column does not contain any duplicate value at the time of insertion and the foreign key columns combined by department_id and manager_id columns contain only those unique combination values, which combinations are exists in the departments table.
Write the SQL statement to generate the report the following 1. Generate a report for all employees in Ascending order 2. Generate a report for all employees in Descending order 3. Generate a report for all employees in Ascending order with their assigned offices 4. Generate a report for all employees in Descending order with their assigned offices 5. Generate a report on customers 6. Generate a report on all customers and assigned sales reps 7. List all payments within a specified time frame of your choice 8. List all the sum total of all products orders. 9. Fetch the highest paying customer. 10. Fetch the highest paying employee 11. Fetch the highest paying product 12. Fetch all orders with complaints 13. Create a report on the total profits of the following offices a. NYC b. London c. Paris d. Tokyo 14. Fetch the lowest paying customer. 15. Fetch the…
Write an SQL statement to list ItemNumber and ItemDescription for all items that cost more that $100 and were produced by an artist with a name ending with the letters son. From Database Management: Chapter 3 Structured Query Language Kroenke
Question One From the Salesman and Customer tables below, write SQL statements to do the following: List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted DESCENDING by rating. List all the customers’ information whose name starts with ‘F’ and the fourth character is ‘I’, rests may be any character. List the name and country of those customers and salesmen who belongs to the same country.
Write the SQL statement to generate the report the following 7. List all payments within a specified time frame of your choice 8. List all the sum total of all products orders. 9. Fetch the highest paying customer.

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS