21. Can you think of another, simpler way to find the department name and its budget for the department with maximum budget? 22. The budget for each department is annual. Write down the query that will show the annual and weekly budget for each department (there are 52 weeks in a year). dept_name annual_budget weekly_budget Biology 90000 100000 Elec. Eng. 85000 1730 1923 cs 1634 Finance 120000 50000 2307 History Music Physics 961 1538 1346 80000 70000

21. Can you think of another, simpler way to find the department name and its budget for the department with maximum budget? 22. The budget for each department is annual. Write down the query that will show the annual and weekly budget for each department (there are 52 weeks in a year). dept_name annual_budget weekly_budget Biology 90000 100000 Elec. Eng. 85000 1730 1923 cs 1634 Finance 120000 50000 2307 History Music Physics 961 1538 1346 80000 70000

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

In what way does SQL differ from other programming languages?
In a database, how can you utilize a sequence?
Below is part of a Student database. The primary keys are highlighted in bold. Student (studNo, studName, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseName, creditHour, level) Project (projNo, projName, courseNo) Assignment (projectNo, studNo, startDate, dueDate, hoursSpent) QUESTION 1. Write a PL/SQL FUNCTION that calculates the cost each student has to pay for all courses taken. In the photo is example the cost detail for each course. 2. Write a PL/SQL Procedure to call the function you created in question 1 . Allow the user to enter the student ID (studno). SECOND PHOTO IS THE EXAMPLE OF EXPECTED OUTPUT
By default, data returned by the SQL SELECT statement is in descending order. a. True b. False
Count the customers who ordered James Austin books. SQL instructions
There are six main parts of a relational database.
How can I practice SQL?
In a database, how can you utilize a sequence?
What is index number ? What are the methods to calculate the index number?
Define the following aggregate functions in an SQL Query. COUNT, MIN, MAX, SUM, AVG
May I request that you elaborate on what SQL is?
What is the purpose of keywords in SQL (Structured Query Language) when writing database queries?