Question: 1) A table contains 4 columns as below: name continent are population Gdp a Write SQL query to a) Give a sum of population' column

1) A table contains 4 columns as below: name

1) A table contains 4 columns as below: name continent are population Gdp a Write SQL query to a) Give a sum of population' column across all continents b) Give the 'name' column with max and min populations c) Give average 'gdp' across all continents 2) Snap of a database table looks as below: 1 2 3 MiddleNa J Lee NULL NULL 4 5 Business Entit... PersonTy FirstNo 1 Ken 2 Tem 3 Roberto 4 Rob 5 Gail 6 Josset 7 Dylan 8 Diane 9 Gigi 10 Michael J.::::::::: LostName Ema Promoti. Snchez D Dutty 1 Tomburello 0 Walters 0 Enckson Goldberg 0 Miller 2 Margheim Matthew 0 Roheem 2 H A Email Address ken@adventure works.com temnog adventure works.com roberto adventure works com robadventure works.com gallo adventure-works.com josseto@adventure-works.com dylano@adventure works com diane adventure-works com gigioadventure-works.com michael adventure works com ModifiedDate 2003-02-08 00.00.00.000 2002 02 24 00:00:00.000 2001-12-05 00 00 00 000 2001-12-29 00:00:00.000 2002-01-30 00:00:00.000 2002-02-17 00 00 00 000 2003-03-05 00 00 00 000 2003-01-23 00 00 00 000 2003-02-10 00.00.00.000 2003 05 28 00.00.00 000 6 7 8 9 9 1 N NULL 10 Extract these columns - first name, middle and last name and their email where email_promotion is set to 1 and email contains only email domain as "adventure-works.com" and only those that were modified in Jan 2002' and after. 3) Imagine you are a Librarian of your department at Lewis University. You are required to identify books that students and faculty borrowed the most in last 2 years. Based on your findings, you are required increase the number of available copies in the library. How would you go about collecting the required data? What type of questions would you work on to achieve your goals

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A table contains 4 columns as below: name continent area population Gd Write SQL query to Give a sum of population column across all continents Give the name column with max and min populations Give...

Q1. Which one of the following statements is false forSQL? (a) SQL supports logical data model concepts (e.g. tables, primarykey, foreign key) (b) All versions of SQL are suitable for recursive...

SA-TIED YOUNG SCHOLARS PROGRAMME Young Scholars This paper was produced as a part of the SA-TIED Young Scholars' programme. The programme is a part of SATIED's capacity building initiatives, designed...

Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Q11 (10 pts) Write SQL to create a table called City in your account. The schema of the table is listed below. You must define the data types and not null constraint (if needed) of every column and...

Create and run a query that displays all employees from the employee table who have the title Senior Sales Associate. This requires that you join related tables and select columns from all them but...

*Using ap SELECT * FROM ap.invoices; SELECT * FROM ap.general_ledger_accounts; SELECT * FROM ap.invoice_line_items; SELECT * FROM ap.vendors; *using MYSQL ap.sql Exercises 1. Write a SELECT statement...

Customer Metrics Google Sheets Tutorial Customer Analytics - Professor Atlas Objectives of Today's Session - Introduction to Google Sheets: orientation, formulas, cell references - Calculate common...

Solve the system of equations by substitution. Sx+ y=0 2x+ 3y = -7 x = 6, y = -6; (6, -6) x = -6, y = 6; (-6, 6) x = 7, y = -7; (7, -7) x = -7, y = 7; (-7, 7) Perform the row operation(s) on the...

Carriage Manufacturing uses an activity-based costing system. The company produces Model 21 and Model 22. Information relating to the two products is as follows: Model 21 Model 22 Units produced...

Cellino and Barnes form Injury Attorneys, a C corporation. Callino contributes several autographed gavels to Injury Attorneys. Cellino purchased the gavels for $ 1 , 0 0 0 , and they have a total...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...