WHERE Statement: “WHERE” statement is used limit the number of rows. For example: Consider a table “FTable” that has two columns named “FruitName” and “Color”. “WHERE” clause is used when there is a need to display the entire FruitName whose color is Red. SELECT * FROM FTable WHERE color = 'red'; When the above statement is executed, red colored fruits get displayed. Grouping Rows: SQL contains “GROUP BY” clause in order to group rows by common data. Though it is very powerful feature, it is hard to understand. Syntax: SELECT column_Name1 FROM table_Name GROUP BY column_Name2; Example: Consider a table “student” contains two columns “student_Name” and “Department”. “GROUP BY” clause is used when there is a need to get the number of students from each department. The query for this scenario is given as follows. SELECT department, COUNT (department) FROM student GROUP BY department; When the above query is executed, number of students from each department will be displayed.

Question

Want to see the full answer?

Answer 1

Question

Chapter 7, Problem 22P

Program Plan Intro

WHERE Statement:

“WHERE” statement is used limit the number of rows. For example: Consider a table “FTable” that has two columns named “FruitName” and “Color”. “WHERE” clause is used when there is a need to display the entire FruitName whose color is Red.

SELECT * FROM FTable WHERE color = 'red';

When the above statement is executed, red colored fruits get displayed.

Grouping Rows:

SQL contains “GROUP BY” clause in order to group rows by common data. Though it is very powerful feature, it is hard to understand.

Syntax:

SELECT column_Name1 FROM table_Name GROUP BY column_Name2;

Example: Consider a table “student” contains two columns “student_Name” and “Department”. “GROUP BY” clause is used when there is a need to get the number of students from each department. The query for this scenario is given as follows.

SELECT department, COUNT (department) FROM student GROUP BY department;

When the above query is executed, number of students from each department will be displayed.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked, sorted by employee number. The results of running that query are shown in Figure P7.6.FIGURE P7.6 TOTAL HOURS AND CHARGES BY EMPLOYEE

Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked, sorted by employee number. The results of running that query are shown in Figure P7.6. EMP_NUM 101 103 104 105 108 113 115 117 EMP_LNAME News Arbough Ramoras Johnson Washington Joenbrood Bawangl Williamson SumOfASSIGN HOURS 3.1 19.7 11.9 12.5 8.3 3.8 12.5 18.8 SumOfASSIGN_CHARGE 387.50 1664.65 1218.70 1382.50 840.15 192.85 1276.75 649.54

Use the following tables to write the SQL queries: Table Name: Employees Write SQL Command to display employee first name , salary and new column called Degree. Evaluate the new column data based on the following EMPLOYEE_ID FIRST_NAME HIRE DATE JOB_ID SALARY DEPARTMENT_ID 100 Steven 02/13/2008 AD PRES 24000 90 101 Neena 05/20/2010 AD_VP 17000 90 102 Lex 09/11/2013 AD VP 17000 90 103 Alexander 09/01/2010 IT PROG 9000 60 104 Bruce 01/17/2012 IT PROG 6000 60 02/21/2018 conditions: 105 David IT PROG 4800 60 If salary is more than 20000 then Degree is PHD If salary is more than 10000 then Degree is 106 Vali 10/04/2018 IT PROG 4800 60 107 Diana 10/06/2019 IT PROG 4200 60 114 Den 08/05/2015 PU_MAN 11000 30 115 Alexander 01/14/2016 PU CLERK 3100 30 Table Name: Departments Table Name: Locations DEPARTMENT_ID DEPARTMENT_NAME LOCATION_ID LOCATION_ID POSTAL_CODE CITY COUNTRY_ID 10 Administration 1700 1400 26192 Southlake US 30 Purchasing 1700 1500 99236 South San Francisco US 50 Shipping 1500…