Consider the following database:Studentsname lastname agerim19182118saramiladtarekismailkamelghantousdibSelect123134134512345RosterIDmajor123EE134EE1345 CCE12345 MEabsenceWrite a query that finds the number of available majors. The output should be 3 for the above instance.) from4724

Answered: Image /qna-images/answer/7437898f-f551-47a9-b77a-8169d088944e.jpg

Consider the following database: Students name rim sara milad tarek lastname age 19 18 21 18 Select ismail kamel ghantous dib ID 123 134 1345 12345 ) from Roster ID 123 134 1345 12345 ME major EE EE CCE Write a query that finds the number of available majors. The output should be 3 for the above instance. absence 7 2 4

Consider the following database: Students name rim sara milad tarek lastname age 19 18 21 18 Select ismail kamel ghantous dib ID 123 134 1345 12345 ) from Roster ID 123 134 1345 12345 ME major EE EE CCE Write a query that finds the number of available majors. The output should be 3 for the above instance. absence 7 2 4

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Database systems In SQL MurachCollege database. Provide a list of all of the students, the number of courses they are taking, and the number of different instructors they have across all of their courses. The first column should provide the last name of each student (column titled Student Last Name). The second column should provide the number of courses that each student is taking (column titled Number of Courses). The third column should provide the number of different instructors that each student has for all of the courses they are taking (column titled Number of Different Instructors). No other columns should be provided in the result. Organize the result by student last name in alphabetical order.
FROM customer WHERE city IN (SELECT city FROM employee WHERE reports_to= 2); 2. SELECT customer.* FROM customer INNER JOIN employee ON customer.city = employee.city WHERE reports_to = 2; Query #1 would be more efficient as it is based on primary and foreign keys. O Query #1 would be more efficient as it is not using indexed columns. Both would be the same as both use the same indices for the join and filter. Query #2 would be more efficient as it is based on primary and foreign keys. 70°F Cloudy QL
In OES4 database, we can verify the values stored in subtotal field by using the following 1: col gross_sales for 99999999 col subtotal for 99999999 select o.order_no,sum(qty*Unit_cost) Gross_Sales, sum(o.subtotal) subtotal from orders o, orderline ol, product p where o.order_no=ol.order_no and ol.product_no=p.product_no group by o.order_no; II: col gross_sales for 99999999 col subtotal for 99999999 select o.order_no,sum(qty*Unit_cost) Gross_Sales, sum(o.subtotal) subtotal from orders o, orderline ol, product p where o.order_no=ol.order_no and ol.product_no=p.product_no group by o.order_no; I & II: are correct I & II: are not correct | || I & II: are not correct I & II: are correct
Some rows of the table STUDENT are shown below: CODE NAME DEPARTMENT GPA YEAR 291 ALEX PSI 3.1 1992 938 MICHELE PHY 2.3 1992 931 JHON MD 3.3 2001 182 JOE MD 3.4 2002 190 REY PHY 2.0 2001 330 RON PSI 3.9 2001 You want the name all departments that have a department GPA average of 2004 greater than the global GPA average. Which query gives you the desired result? a. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT); b. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 AND AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT) GROUP BY DEPARTMENT; c. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT GPA FROM STUDENT GROUP BY DEPARTMENT); d. SELECT * FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT);
Problem 9 Write a query to count the number of invoices.
This is a Database based question.
Update table product to set the value of column productType equal to the corresponding id value in the table productType. This requires a SELECT * FROM productType: to see what the id value is for each type. For example, in my database a. 1|meat b. 2| seafood c. 3| vegetable d. 4 grain and rice e. 5 bakery
Why it's useful to have index that partially sort a query if it doesn't present all of the results already sorted?
This assignment is aimed at building an understanding of how to improve performance within databases by taking advantage the computers hardware by modifying MS SQL settings Prerequisites: Completion of Assignment 1B, reading of Module Readings and Slides. Run the following query to understand how much Memory is currently in use in the database: SELECT physical_memory_in_use_kb/1024 AS sql_physical_memory_in_use_MB, large_page_allocations_kb/1024 AS sql_large_page_allocations_MB, locked_page_allocations_kb/1024 AS sql_locked_page_allocations_MB, virtual_address_space_reserved_kb/1024 AS sql_VAS_reserved_MB, virtual_address_space_committed_kb/1024 AS sql_VAS_committed_MB, virtual_address_space_available_kb/1024 AS sql_VAS_available_MB, page_fault_count AS sql_page_fault_count, memory_utilization_percentage AS sql_memory_utilization_percentage, process_physical_memory_low AS sql_process_physical_memory_low, process_virtual_memory_low AS…
Based on the following authorication commands (ordered from 1 to 4), which of the following privileges is true, assuming that Ali is the owner of the database? Order By Ali 1 2 3 4 Select one: Omar Ali Ali Command Grant Select on Employee to Omar with grant option; Grant Select on Employee to Samer with grant option; Grant Update on Employee to Omar with grant option; Revoke Select on Employee From Omar Cascade; a) Ali and Omar have Update privilege on employee Ali has select privilege on employee b) Ali and Omar have Update privilege on employee Omar and Samer have select privilege on employee elect c) Ali and Omar have Update privilege on employee Ali and Omar have select privilege on employee d) Ali and Omar have Update privilege on employee Ali, Omar and Samer have select privilege on employee
sql
What is the difference between an EXCEPT (MINUS) query and a UNION query?