Write the full sql query including (create,insert,select...) please Create the following tables in your database with the following schema:Table: Countries+-| Column NameТуре| country_id| country_name| int| varcharI-------+country_id is the primary key for this table.Each row of this table contains the ID and the name of one country.Table: Weather+-----| Column Name| Type |country_id| weather state| day| intint| date |+-+------+(country_id,Each row of this table indicates the weather state in a country for one day.day) is the primary key for this table.Add the following data to your tables:Input:Countries table:+------| country_id | country_name |+| 2| 3| USA| Australia| PeruI China| Morocco| Spain| 5+-Weather table:+--| country_id | weather_state | day| 2| 2| 2| 3| 3| 3| 5| 5| 5| 7| 7| 3| 16| 18| 21| 25| 22| 20| 25| 27| 31| 15| 12| 12| -2| 2019-11-07 || 2019-11-09 I| 2019-11-23 || 2019-11-28| 2019-12-01 || 2019-12-02 || 2019-11-05 || 2019-11-15 || 2019-11-25 || 2019-10-23 || 2019-11-01| 2019-10-28| 2019-10-27| 2019-11-10 || 2019-11-11| 2019-11-12| 8| 9| 32019-12-23 Write an SQL query to find the type of weather in each country for November 2019.The type of weather is:• Cold if the average weather_state is less than or equal 15,• Hot if the average weather_state is greater than or equal to 25, and• Warm otherwise.Return result table in any order.The results should be:Output:+-I country_name | weather_type| USA| Australia| Peru| Morocco| China| ColdI Cold| Hot| HotI WarmExplanation:Average weather_state in USA in November is (15) /1= 15 so weather type is Cold.Average weather_state in Austraila in November is (-2 + 0 + 3) /3 = 0.333 so weather type is Cold.Average weather_state in Peru in November is (25) / 1 = 25 so the weather type is Hot.Average weather_state in China in November is (16 + 18 + 21)/3 = 18.333 so weather type is Warm.Average weather_state in Morocco in November is (25 + 27+31)/3 = 27.667 so weather type is Hot.We know nothing about the average weather_state in Spain in November so we do not include it inthe result table.

As per our guidelines, only 3 sub parts will be answered. So, please repost the remaining questions…

Create the following tables in your database with the following schema: Table: Countries | Column Name 1 Туре | country_id country_name I varcharI I int country_id is the primary key for this table. Each row of this table contains the ID and the name of one country. Table: Weather | Column Name | Туре I ----- | int country_id weather_state | int day | date | +------+ (country_id, day) is the primary key for this table. Each row of this table indicates the weather state in a country for one day. Add the following data to your tables: Input: Countries table: | country_id I country_name | +- | USA | Australia 2 | 3 Peru I China | Morocco | Spain 9

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: In SQL: Explicit Cursors also have Attributes. Name one of the four explicit cursor attributes and…

A: Indeed, Explicit cursors in database systems have attributes that will describe the behavior of the…

Q: Write an SQL query to find how many years in between the current date and return_date, arrange the…

A: Here, Query instructions are given.

Q: Which SQL Command is used to delete a table from the database: a) Update b) Alter c) Drop d) Şelect

A: Update Command is used to update the value in a table. Alter command is used to change the value in…

Q: database with Howing BUIMOTTO Table: Employees | Column Name 1 Туре I id | int | varchar I I name…

A: The SQL queried is given below.

Q: abel each question beginning 1 to match the numbers below. I Primary Keys / Foreign Keys / Default…

Q: Write single-table queries using SQL commands.

A: Steps to write single query: SELECT col1, col2, ... FROM table_name; SELECT * FROM table_name;

Q: Choosing rows from the table Recall that the WHERE clause in an SQL statement specifies conditions…

A: To modify the select query to filter the result where LastName as Kay in the Employees table using…

Q: List and describe the five SQL privileges available with the GRANT or REVOKE statements.

A: answer is

Q: Please give a detailed answer and code examples for all the questions. What are the types of SQL…

A: What is a SQL join A SQL Join is a special form of generating a meaningful data by combining…

Q: write my sql , p/sql pr t-sql procedures to retrieve and output the item id, description, location,…

A: Your mysql query is given below.

Q: In Visual basics explain the meaning of the listed SQL commands : (a)ORDER BY (b)INNER JOIN…

A: In the context of SQL (Structured Query Language), which is a language used to communicate with and…

Q: Write a SQL query that would display only each unique salary from an employee table.

A: Your answer is given below.

Question

Write the full sql query including (create,insert,select...) please

Create the following tables in your database with the following schema:
Table: Countries
+-
| Column Name
Туре
| country_id
| country_name
| int
| varcharI
-------+
country_id is the primary key for this table.
Each row of this table contains the ID and the name of one country.
Table: Weather
+-----
| Column Name
| Type |
country_id
| weather state
| day
| int
int
| date |
+-
+------+
(country_id,
Each row of this table indicates the weather state in a country for one day.
day) is the primary key for this table.
Add the following data to your tables:
Input:
Countries table:
+-
-----
| country_id | country_name |
+
| 2
| 3
| USA
| Australia
| Peru
I China
| Morocco
| Spain
| 5
+-
Weather table:
+--
| country_id | weather_state | day
| 2
| 2
| 2
| 3
| 3
| 3
| 5
| 5
| 5
| 7
| 7
| 3
| 16
| 18
| 21
| 25
| 22
| 20
| 25
| 27
| 31
| 15
| 12
| 12
| -2
| 2019-11-07 |
| 2019-11-09 I
| 2019-11-23 |
| 2019-11-28
| 2019-12-01 |
| 2019-12-02 |
| 2019-11-05 |
| 2019-11-15 |
| 2019-11-25 |
| 2019-10-23 |
| 2019-11-01
| 2019-10-28
| 2019-10-27
| 2019-11-10 |
| 2019-11-11
| 2019-11-12
| 8
| 9
| 3
2019-12-23

Write an SQL query to find the type of weather in each country for November 2019.
The type of weather is:
• Cold if the average weather_state is less than or equal 15,
• Hot if the average weather_state is greater than or equal to 25, and
• Warm otherwise.
Return result table in any order.
The results should be:
Output:
+-
I country_name | weather_type
| USA
| Australia
| Peru
| Morocco
| China
| Cold
I Cold
| Hot
| Hot
I Warm
Explanation:
Average weather_state in USA in November is (15) /1= 15 so weather type is Cold.
Average weather_state in Austraila in November is (-2 + 0 + 3) /3 = 0.333 so weather type is Cold.
Average weather_state in Peru in November is (25) / 1 = 25 so the weather type is Hot.
Average weather_state in China in November is (16 + 18 + 21)/3 = 18.333 so weather type is Warm.
Average weather_state in Morocco in November is (25 + 27+31)/3 = 27.667 so weather type is Hot.
We know nothing about the average weather_state in Spain in November so we do not include it in
the result table.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

Q7. What are some common clauses used with SELECT query in SQL?
<!doctype html><html><head><meta charset="UTF-8"><title>Black Goose Bakery</title><meta name="viewport" content="width=device-width, initial-scale=1"><link href="https://fonts.googleapis.com/css?family=Stint+Ultra+Expanded" rel="stylesheet"><style>@import url(bakery-styles.css);</style> </head> <body> <header> <nav> <ul> <li><a href="">Menu</a></li> <li><a href="">News</a></li> <li><a href="">About</a></li> <li><a href="">Contact</a></li> </ul> </nav> <h1><img src="images/bgb_logo.png" alt="Black Goose Bakery"></h1> <p>The delicious baked goods you love at Black Goose Bistro...now available to go!</p></header> <main> <h2>Fresh from the Oven</h2> <h3>Breads</h3> <p><img…
Write SQL a query to find out the structure of the table Table name:- BankSystm
Write an SQL query to extract the answer directly.
Write an SQL query to extract the answer directly.
Please solve question no. 10 including screenshots of SQL results.