* A - Querying tables city and country:*/ /* 1 - Using INNER JOIN ..ON, write...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
* A - Querying tables city and country:*/ /* 1 - Using INNER JOIN ..ON, write a query that displays the name of cities, the cities' population and cities' continent. Sort the result by continent, then by city population, then by city name. Note that the field called 'name' is present in the two tables, use a table alias to resolve the conflict. */ /* 2 - Rewrite the previous query using WHERE/FROM instead of INNER JOIN. */ /* 3 - Rewrite the query in question 1 to countries that became independent in 1960. */ /* 4 - Rewrite the previous query using WHERE/FROM instead of INNER JOIN. */ /* 5 - Using INNER JOIN ..ON, write a query that displays, for the city of Ottawa, the name of the city and the head of state of its country. */ /* 6 - Using INNER JOIN ..ON, write a query that displays the name of the city, the city population, the continent, and the country population of the city of Toronto. */ /* B - Querying tables city and countryLanguage:*/ /* 1 - Using INNER JOIN ..ON, write a query that answers the following question. What languages along with their percentage are spoken in the city of Ottawa? */ /* 2 - Using WHERE/FROM, write a query that answers the following question. What official languages along with their percentage are spoken in the city of Ottawa? */ /* 3 - Using INNER JOIN ..ON, write a query that reports the percentage of people speaking an official language in the city of Ottawa as well as the percentage of people speaking Polish in the city of Ottawa */ /* 4 Using INNER JOIN ..ON and SUM, write a query that reports the total percentage of people speaking an official language as well as speaking Italian in the city of Ottawa */ /* C - Querying tables city, country and countryLanguage:*/ /* 1 - Using INNER JOIN ..ON the three tables, write a query that displays the name of the city, the city continent, the city head of state, the year of independence and the total number of people who speak Italian in the city of Toronto. */ /* 2 - Rewrite the previous query using WHERE/FROM instead of INNER JOIN. */ /* 3 - Using LEFT JOIN ..ON the three tables, write a query that displays the city continent, the country the city is in, the city name and the language spoken in that city */ Note: Try to solve those questions in DataGrip. Program: Database System - CST8260 * A - Querying tables city and country:*/ /* 1 - Using INNER JOIN ..ON, write a query that displays the name of cities, the cities' population and cities' continent. Sort the result by continent, then by city population, then by city name. Note that the field called 'name' is present in the two tables, use a table alias to resolve the conflict. */ /* 2 - Rewrite the previous query using WHERE/FROM instead of INNER JOIN. */ /* 3 - Rewrite the query in question 1 to countries that became independent in 1960. */ /* 4 - Rewrite the previous query using WHERE/FROM instead of INNER JOIN. */ /* 5 - Using INNER JOIN ..ON, write a query that displays, for the city of Ottawa, the name of the city and the head of state of its country. */ /* 6 - Using INNER JOIN ..ON, write a query that displays the name of the city, the city population, the continent, and the country population of the city of Toronto. */ /* B - Querying tables city and countryLanguage:*/ /* 1 - Using INNER JOIN ..ON, write a query that answers the following question. What languages along with their percentage are spoken in the city of Ottawa? */ /* 2 - Using WHERE/FROM, write a query that answers the following question. What official languages along with their percentage are spoken in the city of Ottawa? */ /* 3 - Using INNER JOIN ..ON, write a query that reports the percentage of people speaking an official language in the city of Ottawa as well as the percentage of people speaking Polish in the city of Ottawa */ /* 4 Using INNER JOIN ..ON and SUM, write a query that reports the total percentage of people speaking an official language as well as speaking Italian in the city of Ottawa */ /* C - Querying tables city, country and countryLanguage:*/ /* 1 - Using INNER JOIN ..ON the three tables, write a query that displays the name of the city, the city continent, the city head of state, the year of independence and the total number of people who speak Italian in the city of Toronto. */ /* 2 - Rewrite the previous query using WHERE/FROM instead of INNER JOIN. */ /* 3 - Using LEFT JOIN ..ON the three tables, write a query that displays the city continent, the country the city is in, the city name and the language spoken in that city */ Note: Try to solve those questions in DataGrip. Program: Database System - CST8260
Expert Answer:
Related Book For
Accounting Information Systems
ISBN: 9780132871938
11th Edition
Authors: George H. Bodnar, William S. Hopwood
Posted Date:
Students also viewed these databases questions
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
paraphrase the following two passages using narrative in-text citations: 1.Those who teach ethics don't need to look far for lessons. Every day there's fresh scandal: Google is in hot water for how...
-
Why is inductive reasoning utilized in social science? How does it differ from deductive reasoning?
-
Miguel, Inc. reported net income of $2.5 million in 2017. Depreciation for the year was $160,000, accounts receivable decreased $350,000, and accounts payable decreased $280,000. Compute net cash...
-
Given a WT with the following parameters, calculate the annual energy production assuming a Rayleigh PDF: \(C_{p}=C_{p \max }=0.40\left(C_{p} ight.\) value assumed maximum and constant for all wind...
-
Identify the use cases for the following system: Picnics R Us (PRU) is a small catering firm with five employees. During a typical summer weekend, PRU caters 15 picnics for 20 to 50 people each. The...
-
JB Associates earned a net income of $4.5 million in 2009. The company announced dividends of $0.818 per share, which will grow at a constant rate forever. Given that the weighted average number of...
-
Fraley Chemical Company accounts for its production activities using weighted average (WA) process costing. Inventory records for the process show a January 1 work-in-process inventory of 10,000...
-
A loan company charges $ 9 0 interest for a one month loan of $ 2 2 5 0 . Find the annual interest rate they are charging .
-
How do leaders leverage emotional intelligence to inspire and motivate diverse teams, fostering a sense of belonging and purpose amidst dynamic challenges?
-
what ways do authentic leaders foster a culture of trust and transparency within their teams, and how does this contribute to long-term organizational success?
-
How do different organizational structures impact employee engagement, job satisfaction, and overall well-being, and what strategies can organizations em ploy to design structures that promote...
-
How do emerging theories such as complex adaptive systems and network theory challenge traditional hierarchical models of organizational structure, and what implications do they have for...
-
1. Mark all that apply regarding Mastercards competitive positioning. It's a virtual duopoly with Visa makes win-win strategies profitable for both parties. The payment industry has significant...
-
For the vector whose polar components are (Vr = 1, Vθ = 0), compute in polars all components of the second covariant derivative Vα;μ;ν. To find...
-
Barbara Carson is a high- ranking officer in the Marines. She has recently been placed in charge of computer-assisted design and manufacturing for a highly classified project relating to a new high-...
-
As part of an audit engagement, you have been assigned the task of documenting the internal control system for the Brown Sole Shoe Store. The business is operated by a single owner, who operates the...
-
List the four types of master records that are used in SAP ERP.
-
The electric motor with an attached disk is running at a constant low speed of \(120 \mathrm{rev} / \mathrm{min}\) in the direction shown. Its housing and mounting base are initially at rest. The...
-
The motor housing and its bracket rotate about the \(Z\)-axis at the constant rate \(\Omega=3 \mathrm{rad} / \mathrm{s}\). The motor shaft and disk have a constant angular velocity of spin \(p=8...
-
The bent plate has a mass of \(70 \mathrm{~kg}\) per square meter of surface area and revolves about the \(z\)-axis at the rate \(\omega=30 \mathrm{rad} / \mathrm{s}\). Determine (a) the angular...
Study smarter with the SolutionInn App