code of create table and insert table only 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.

We need to write code of create table and insert table only.

Create the following tables in your database with the following schema: Table: Countries | Column Name | Туре | country_id I 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 1 Туре I ---- I country_id | weather state | int I day | int | 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: +------------ I country_id | country_name | | USA | Australia | Peru I China | Morocco | Spain | 2 Weather table: +---------- | country_id | weather_state | day | 2019-11-01 | | 2019-10-28 | | 2019-10-27 | | 2019-11-10 | | 2019-11-11 | | 2019-11-12 | | 2019-11-07 I | 2019-11-09 | | 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-12-23 | | 2 | 2 | 2 | 15 | 12 | 12 | -2 | 3 | 16 | 18 | 21 | 25 | 22 | 20 | 25 | 27 | 31 | 7 1 3

Create the following tables in your database with the following schema: Table: Countries | Column Name | Туре | country_id I 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 1 Туре I ---- I country_id | weather state | int I day | int | 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: +------------ I country_id | country_name | | USA | Australia | Peru I China | Morocco | Spain | 2 Weather table: +---------- | country_id | weather_state | day | 2019-11-01 | | 2019-10-28 | | 2019-10-27 | | 2019-11-10 | | 2019-11-11 | | 2019-11-12 | | 2019-11-07 I | 2019-11-09 | | 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-12-23 | | 2 | 2 | 2 | 15 | 12 | 12 | -2 | 3 | 16 | 18 | 21 | 25 | 22 | 20 | 25 | 27 | 31 | 7 1 3

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

To test weather a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. Or, when you're using mySQL Workbench, you can right-click on a table name in the navigator window and select the Select Rows - Limit 1000 command to display the data for the table in a Result tab. To refresh the data in this tab after modifying the table data, click the Refresh button in the toolbar at the top of the tab.1. Write an INSERT statement that adds this row to the Terms table: terms_id: 6 terms_description: Net due 120 days terms_due_days: 120 Use MySQL Workbench to review the column definitions for the Terms table, an dinclude a column list with the required columns in the insert statement. 2. Write an UPDATE statement that modifies the row you just added to the Terms table. This statement should change the terms_description column to "Net due…
Pages with porn should get the Porn flag even if the query is looking for porn results. a) True b) False
Which results would show if the artist table LEFT JOINed the album table? Only rows from the artist table that do not have related albums in the album table Only artists from the artist table that have albums All artists, even those with no albums in the album table All rows from the album table, even those that have NULL artist_id's
The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
use the code below to create tabels. include screenshots of each completed table. CREATE TABLE PRICE ( PRICE_CODE NUMBER(2,0) PRIMARY KEY, PRICE_DESCRIPTION VARCHAR2(20) NOT NULL , PRICE_RENTFEE NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0), PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0) ); CREATE TABLE MOVIE ( MOVIE_NUM NUMBER(8,0) PRIMARY KEY, MOVIE_TITLE VARCHAR2(75) NOT NULL, MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); CREATE TABLE MEMBERSHIP ( MEM_NUM NUMBER(8,0) PRIMARY KEY, MEM_FNAME VARCHAR2(30) NOT NULL, MEM_LNAME VARCHAR2(30) NOT NULL, MEM_STREET VARCHAR2(120), MEM_CITY VARCHAR2(50), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER(10,2) ); PRICE: INSERT INTO PRICE VALUES (1, 'Standard', 2, 1);…
The incomplete box plot and table show some information about some marks. Use the information in the table to complete the box plot. Use the information in the box plot to complete the table.
Please help me with the syntax to create a table in Snowflake.
when you do following $("table") what it will select last table from the document all tables from the document first table from the document
Jump to level 1 Country ISOCode2 Name Code HU Hungary 348 DE BY Germany 276 Belarus 112 Complete the statement to delete the row containing 'Belarus'. In the WHERE clause, identify the row to be deleted using the ISOCode2 column. DELETE FROM Country WHERE
Create a new query in Design View that is based on the tblCoach and tblLevel table Add the LevelName field from the tblLevel table to the query design. Add the CoachFirst, CoachLast, BGCExp, and CertificationExp fields, in that order, from the tblCoach table. Use qryCoachBGCExpirations to save query. Add criteria to the BGCExp field to select records with BGCExp dates that occur on or before 12/31/2019. Save and run the query, and then close it.
CREATE TABLE consumer ( ConsumerID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Age INT, Gender VARCHAR(10), OnlineInStore VARCHAR(20)); INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (1, 'John', 'Doe', 25, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (2, 'Jane', 'Smith', 30, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (3, 'Mike', 'Johnson', 20, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (4, 'Sarah', 'Williams', 35, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (5, 'Chris', 'Davis', 28, 'Male', 'Online'); CREATE TABLE InStoreRetailer ( RetailerID INT PRIMARY KEY, RetailerName VARCHAR(50), StoreLayout VARCHAR(50), CustomerService…