solved: SQL questions 1) Count the number of departments. Select Count…

  

SQL questions 1) Count the number of departments. Select Count…Image transcription textemp no emp_fname emp_Iname dept no 25348 Matthew Smith d3 10102 Ann Jones d3 18316 John Barrimored1 29346 James James d2 9031 Elke Hansel d2 2581 Elsa Bertoni d2 28559 Sybill Moser d1 Table 1-2 TheEmployee Table project no project_name budget p7 Apollo 120000 p2 Gemini 95000 p3 Mercury… Show more… Show moreSQL questions1) Count the number of departments.Select Count ([dept_no])from [dbo].[department]  2) What is the department number for Accounting?select [dept_no]from [dbo].[department]where [dept_name] = ‘Accounting’  3) List department names for departments located in Dallas. Select [dept_name]from [dbo].[department]where [location] = ‘Dallas’ Using the project table, answer the following questions: 4) How many projects are in the table?Select Count([project_no])from [dbo].[project]  5) How many projects have a name that end with eth letter o?Select Count([project_name])from [dbo].[project]where [project_name] like ‘%o’  6) What is the total budget for all projects?Select Sum([budget])from [dbo].[project]  7) What is the most expensive budget?select Max([budget])from [dbo].[project]  8) List project name and budget.  Order by budget descending. select [project_name], [budget]from [dbo].[project]Order by [budget] Desc Using the work_on table, answer the following questions: 9) How many unique jobs are listed in the table?Select Count(Distinct([job]))from [dbo].[works_on]  List all employee numbers and dates where the work began after May 2007Select [emp_no], [enter_date] from [dbo].[works_on] where [enter_date] >= ‘2007-06-01’ Computer ScienceEngineering & TechnologyMYSQLBADM 7301