* 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...
-
How does scientific inquiry try to avoid the common pitfalls that produce error in nonscientific inquiry?
-
Pal Corporation purchased a 90 percent interest in Sal Corporation on December 31, 2010, for $2,700,000 cash, when Sal had capital stock of $2,000,000 and retained earnings of $500,000. All Sal's...
-
The Howell Corporation has the following account balances (in millions): Prepare an income statement and a supporting schedule of cost of goods manufactured for the year ended December 31, 2017. (For...
-
Outline a research design using observation for each of the following situations: a. A bank wishes to collect data on the number of customer services and the frequency of customer use of these...
-
When President Obama was President he had discussed raising income taxes for individuals earning over $250,000 in income. Explain how these higher income taxes will affect the aggregate demand curve....
-
Consider the following two models for evaluating the performance of PPTRX: 1. One factor model with respect to S&P 500 returns. 2. Two factor model with respect to S&P 500-and 10-Year Treasury...
-
How often will a statement usually be sent out if there is a balance on the account? b.) In which part of the process is patient information verified? c.) What percentage comes from private pay...
-
Tell why an effective internal control system is necessary and what it is expected to accomplish. Give examples of internal controls designed to protect - a company's cash, its inventory, and the...
-
Your friend Jeanie Alahgee has researched her family tree and finds that a large number of her family members have either red hair or blond hair and either green eyes or blue eyes. She makes a list...
-
Which forms is used by financial institutions to report potential money laundering or other possible criminal activity?
-
Prepare an analysis discussing if you think this FASB proposal of Accounting Standards Update(ASU) 2023 is a good idea now that you have seen the impact on the financial statements of the Target...
-
Miller Outdoor Equipment (MOE) makes four models of tents. The model names are Rookie, Novice, Hiker, and Expert. MOE manufactures the tents in two departments: Stitching and Customizing. All four...
-
Give the products of the following reaction, where T is tritium: dioldehydrase Ad- CH CH3C-COH CoIII) coenzyme B12
-
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.
-
Meet local small business owners or representatives of as profit organizations. Find a company or organization that will host your team to produce a web site for them (nonmonetary, of course). Find...
-
More often than not, database environments in in organization reflect data structures that have been developed over a period of years, sometimes haphazardly, and that often reflect a variety of...
-
Although database systems have become the systems of choice for new and reengineered systems, are there any situations where a relational file-based system might be chosen instead? Explain your answer
Study smarter with the SolutionInn App