please write a list of sql queries for these exercises
5. Display a list of countries whose official language is English. Show the names of the countries in alphabetical order.
sql query to display country names, whose official language is English, in sorted order.
To print Countries in sorted order use clause "ORDER BY "
-----------------------------------------------------
sql query:
________________________
SELECT country
FROM COUNTRIES
WHERE language='English'
ORDER BY country
please write a list of sql queries for these exercises 5. Display a list of countries...
Subject : computer science -web development Qus: using the database tables below write the SQL queries: ( SELECT; FORM; WHERE; ORDER BY; DISTINCT; GROUP BY; COUNT(); SUM(); AVG(); MAX(); MIN(); JOIN; ON) Student (StudentId, Major, GPA) Transcript( Studentid, CourseNo, Gread); Course( CourseNo, Title, Credits) Display the title of the course(s) that are 3 credits? Display the average GPA of the students Majoring in ‘CSC’ List non duplicated major(s) of students who have received a grades of ‘A’ in CSC350 List...
Given the following relational schema, write queries in SQL to answer the English questions. The Access Database for the schema is available, as is a DDL file. It is also available on the MySQL server. You must only submit the SQL for your answers. You can get your answers without using a DBMS or by using Access or MySQL. Customer(cid: integer, cname: string, address: string, city: string, state: string) Product(pid: integer, pname: string, price: currency, inventory: integer) Shipment(sid: integer, cid:...
Write SQL queries to answer the following questions: a. List the numbers of all sections of course ISM 4212 that are offered during the semester “II-2015.” b. List the course IDs and names of all courses that ends with the letters “Analysis” c. List the IDs of all faculty members who are qualified to teach both ISM 4212 and ISM 3113. Make sure to only list one ID for each faculty. d. Modify the query above in part c so...
1.If you do not have the world schema you can obtain the scripts to create the database schema from https://dev.mysql.com/doc/index-other.html Queries 1. Write a SQL subquery that shows the unique region names where the languages spoken are English, French or German. 2. Write a SQL query that shows the country name, region, language for the Caribbean region 3. Write a SQL query that shows the country name once and shows the number of cities in that country. The number of...
if you do not have the world schema you can obtain the scripts to create the database schema from https://dev.mysql.com/doc/index-other.html Queries Write a SQL query that shows all the columns in the country table for the North America region. The results need to be sorted in ascending order by population. Write a SQL query that shows the unique regions in the country table except for the regions from the continent of Oceania. The results need to be sorted in ascending...
Express the following queries in SQL. Only standard SQL syntax is allowed. Each query should be answered in a single SQL statement: 1. Find the name of suppliers that are located in Mumbai. 2. Find the name of suppliers and the names of parts they sell. List the result in descending order suppliers name. 3. Find the names of parts that are sold by exactly two suppliers. 4. Find the names of parts that are sold by all suppliers. 5....
Write the sql statement that returns a list of store's cities and countries. Where are they located (city and country)? Show your results. Write the sql statement that returns the total revenue for those stores. Show your results including store number, city and country. Write the sql statement that returns the total revenue per year for those stores. Show your results including store number, city and country. Write the sql statement that returns the average revenue per month regardless of...
Given the following relational schema, write queries in SQL to answer the English questions. There is a shipment database on the MySQL server. You can also use the DDL for MySQL. You must only submit the SQL for your answers but you can include the query output as well to help the TA with marking. Customer(cid: integer, cname: string, address: string, city: string, state: string) Product(pid: integer, pname: string, price: currency, inventory: integer) Shipment(sid: integer, cid: integer, shipdate: Date/Time) ShippedProduct(sid:...
Write the sql statement that returns a list of store's cities and countries. Where are they located (city and country)? Show your results. Write the sql statement that returns the total revenue for those stores. Show your results including store number, city and country. Write the sql statement that returns the total revenue per year for those stores. Show your results including store number, city and country. Write the sql statement that returns the average revenue per month regardless of...
SQL Queries – in this assignment you will be asked to create several SQL queries relating to the Sakila database that we installed in class. You may freely use DBeaver to create these queries, but I will expect your solution to show me the SQL code to answer or complete the tasks below. Write a query that produces the last name, first name, address, district, and phone number for every customer in the customer table. (You don’t need to include...