Blog

Which of the following are included in GDP? Select all that apply.

Find the employees’ who have last names starting with the letter “B”. Include their first name and department as well. Results Grid first_name last_name department_name Shelli Baida Purchasing Sarah Bell Shipping Hermann Baer Public Relations

Find the name of the department, its city, and the number of employees in that department, only for the departments with the fewest employees. Hint: Use a subquery Results Grid department_name city employee_count Administration Seattle 1 Human Resources London 1 Public Relations Munich 1  

Create a view named employee_full_info that displays the employee’s full name, job title, department name, city, salary, and the full name of each dependent (if any). If an employee has no dependents, still include them in the result. Order the output by department name and then employee’s last name. Results Grid employee_name job_title department_name city salary dependent_name William Gietz Public Accountant Accounting Seattle 8300.00 Penelope Gietz Shelley Higgins Accounting Manager Accounting Seattle 12000.00 Nick Higgins Jennifer Whalen Administration Assistant Administration Seattle 4400.00 Ed Whalen Lex De Haan Administration Vice President Executive Seattle 17000.00 Bette De Haan Steven King President Executive Seattle 24000.00 Jennifer King Neena Kochhar Administration Vice President Executive Seattle 17000.00 Johnny Kochhar John Chen Accountant Finance Seattle 8200.00 Matthew Chen Daniel Faviet Accountant Finance Seattle 9000.00 Grace Faviet Nancy Greenberg Finance Manager Finance Seattle 12000.00 Karl Greenberg Luis Popp Accountant Finance Seattle 6900.00 Zero Popp Ismael Sciarra Accountant Finance Seattle 7700.00 Joe Sciarra Jose Manuel Urman Accountant Finance Seattle 7800.00 Christian Urman Susan Mavris Human Resources Representatives Human Resources London 6500.00 Uma Marvis David Austin Programmer IT Southland 4800.00 Fred Austin Bruce Ernst Programmer IT Southland 6000.00 Cuba Ernst Alexander Hunold Programmer IT Southland 9000.00 Vivien Hunold

Find the employees’ who have last names starting with the letter “B”. Include their first name and department as well. Results Grid first_name last_name department_name Shelli Baida Purchasing Sarah Bell Shipping Hermann Baer Public Relations

Show the employee names along with the names of their dependents. Display the result with the employee’s full name and their dependent’s full name. Order the output by employee’s last name and then by dependent’s first name. Hint: Use CONCAT(). Results Grid Employee Name Dependent Name David Austin Fred Austin Hermann Baer Kirsten Baer Shelli Baida Sandra Baida John Chen Matthew Chen Karen Colmenares Rip Colmenares Lex De Haan Bette De Haan Bruce Ernst Cuba Ernst Daniel Faviet Grace Faviet Pat Fay Lucille Fay William Gietz Penelope Gietz Nancy Greenberg Karl Greenberg Michael Hartstein Bob Hartstein Shelley Higgins Nick Higgins Guy Himuro Kevin Himuro

Find the departments and number of employees that have no dependents, using a subquery. Results Grid department_name count(*) Shipping 7 Sales 3

I figured everything out and Honorlock is working!

Given the following table, how would you answer the following questions? How much total precipitation is there for each weather condition? (Note: precipitation is an integer and weatherCondition are types of weather (sunny, rain, snow, etc…)) Image Long Description The dailyWeather entity contains the following attributes and data types: date DATE MinTemp INT MaxTemp INT precipitation INT weatherCondition VARCHAR(45)

Based on the following ER Diagram from the database called “StudentFinancial.” What SQL statement would you use to answer the following question? Image Long Description The “Student” entity is connected to the “Tuition” entity with a one-to-relationship labeled “Pays”. Student Entity and Attributes PSUID INT (primary key) FirstName VARCHAR(45) LastName VARCHAR(45) Email VARCHAR(45) Department VARCHAR(45) Tuition Entity and Attributes tuitionID INT (primary key) Student INT (foreign key) SemesterCost INT Scholarships INT DueDate INT What is the total semester cost per due date? SELECT [attributes]FROM Tuition[clause]