Computer Science · SQL and Database Queries
Consider the following dataset for a Projects table: Proj_ID | Proj_Name | Start_Date | Budget1 | Phoenix | 2022-05-10 | 50002 | Apollo | 2021-11-20 | 80003 | Zenith | 2023-01-15 | 30004 | Orion | 2022-08-30 | 120005 | Titan | 2021-03-05 | 4500 Calculate the output of the following SQL query: SELECT MIN(Proj_Name), MAX(Start_Date), MAX(Budget) - MIN(Budget) FROM Projects;
- 1Zenith, 2021-03-05, 9000
- 2Apollo, 2023-01-15, 7000
- 3Phoenix, 2022-08-30, 9000
- 4Apollo, 2023-01-15, 9000✓
Correct answer
Apollo, 2023-01-15, 9000
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on SQL and Database Queries?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · SQL and Database Queries