DROP DATABASE class;CREATE DATABASE class;Use class;drop table if exists Class;drop table if exists Student;CREATE TABLE Class (CIN int PRIMARY KEY, FirstName varchar(255), LastName varchar(255), Gender varchar(1), EyeColor varchar(50), HairColor varchar(50), HeightInches int,CurrentGrade varchar(1));CREATE TABLE Student (SSN int PRIMARY KEY,FirstName varchar(255),LastName varchar(255), Age int,BirthMonth varchar(255),HeightInches int,Address varchar(255),City varchar(255),PhoneNumber varchar(12),Email varchar(255),FavColor varchar(255),FavNumber int);INSERT INTO Class VALUES(1, "David", "San", "M", "BRN", "BLK", 72, "-");INSERT INTO Class VALUES(2, "Jeff", "Gonzales", "M", "BRN", "BLK", 68, "B");INSERT INTO Class VALUES(3, "Anna", "Grayson", "F", "BRN", "BRN", 62, "A");INSERT INTO Class VALUES(4, "Kathryn", "Moloney", "F", "GRN", "BLK", 68, "B");INSERT INTO Class VALUES(5, "Randy", "Bernard", "M", "GRN", "BRN", 69, "A");INSERT INTO Class VALUES(6, "Andy", "Lam", "M", "BRN", "BLK", 59, "C");INSERT INTO Class VALUES(7, "Makoto", "Yuki", "F", "BRN", "BRN", 61, "A");INSERT INTO Class VALUES(8, "Pranil", "Watakana", "M", "BRN", "BLK", 63, "D");INSERT INTO Class VALUES(9, "Pierce", "Santos", "M", "BRN", "BLK", 74, "B");INSERT INTO Class VALUES(10, "Soliel", "Estrada", "F", "BRN", "BLU", 66, "B");INSERT INTO Class VALUES(11, "Jeff", "Bezos", "M", "BRN", "BRN", 65, "B");INSERT INTO Class VALUES(12, "Andy", "Chen", "M", "BRN", "BLK", 69, "A");INSERT INTO Class VALUES(13, "Makoto", "Amagi", "F", "BRN", "BRN", 64, "C");INSERT INTO Student VALUES(1, "David", "San", 22, "March", 72, "1234", "Flowerville", "231-246-4361", "[email protected]", "Blue", 7);INSERT INTO Student VALUES(2, "Randy", "Bernard", 21, "February", 69, "7123", "Rossette Park", "634-124-7452", "[email protected]", "Green", 12);INSERT INTO Student VALUES(3, "Andy", "Lam", 24, "December", 59, "9072", "Jefferson", "124-564-6354", "[email protected]", "Grey", 32);INSERT INTO Student VALUES(4, "Pranil", "Watakana", 23, "February", 63, "2146", "Rossette Park", "543-325-3521", "[email protected]", "Grey", 3);INSERT INTO Student VALUES(5, "Jeff", "Bezos", 22, "April", 65, "6312", "Grey Valley", "351-532-6439", "[email protected]", "Yellow", 0);INSERT INTO Student VALUES(6, "Makoto", "Amagi", 21, "September", 64, "39857", "Flowerville", "314-352-5321", "[email protected]", "Black", 3);

INSERT INTO Student VALUES(7, "Jeff", "Gonzales", 20, "October", 68, "4361", "Flowerville", "231-342-5467", "[email protected]", "Blue", 21);INSERT INTO Student VALUES(8, "Anna", "Grayson", 21, "January", 62, "6543", "Rossette Park", "634-423-5763", "[email protected]", "Green", 12);INSERT INTO Student VALUES(9, "Kathryn", "Moloney", 24, "May", 68, "5437", "Jefferson", "124-684-4131", "[email protected]", "Grey", 3);INSERT INTO Student VALUES(10, "Makoto", "Yuki", 19, "April", 61, "75632", "Rossette Park", "543-354-6421", "[email protected]", "Grey", 7);INSERT INTO Student VALUES(11, "Pierce", "Santos", 21, "January", 74, "3543", "GreyValley", "351-542-7541", "[email protected]", "Yellow", 10);INSERT INTO Student VALUES(12, "Soliel", "Estrada", 20, "June", 66, "3754", "Flowerville", "314-325-6543", "[email protected]", "Black", 5);INSERT INTO Student VALUES(13, "Andy", "Chen", 22, "September", 69, "3865", "Flowerville", "314-231-4233", "[email protected]", "Black", 3);

-----------------------------------------------------------------------------------------------------------------------

1. Assign grades for students who lived in Rossette Park to be a B
2. Add another table for students who had an altered grade (in this case students who lived in Rossette Park)
3. Add the CIN, FirstName, LastName, Gender, Address, City, and Email of the students who had an altered grade to the table
4. Remove students from the student table who live in Rossette Park
5. Join all 3 tables and display the Names, Gender, and City of the students (Going to need to use ON)

Use
SET SQL_SAFE_UPDATES = 0;
To disable Safe Mode if prompted.

Not sure where to begin, as my instructor taught the theory but never any live coding session.

Is there a difference between the means of the total of rooms per hotel in Crete and Southern Aegean Islands? Answer your question by calculating an appropriate, symmetric, 95% confidence interval using a Z statistic and equal standard deviations in the two populations. Explain your findings.

REGION ID

1= Crete
2=Southern Aegean Islands
3=Ionian Islands

Is there a difference between the means of the total of rooms per hotel in Crete and Southern Aegean Islands? Answer your question by calculating an appropriate, symmetric, 95% confidence interval using a Z statistic and equal standard deviations in the two populations. Explain your findings

REGION ID

1= Crete
2=Southern Aegean Islands
3=Ionian Islands

The manager of a resort hotel stated that the mean guest bill for a weekend is $600 or less. A member of the hotel's accounting staff noticed that the total charges for guest bills have been increasing in recent months. The accountant will use a sample of future weekend guest bills to test the manager's claim.

(a)

Which form of the hypotheses should be used to test the manager's claim? Explain.

H₀: μ ≥ 600

H_a: μ < 600

H₀: μ ≤ 600

H_a: μ > 600

H₀: μ = 600

H_a: μ ≠ 600

A) The hypotheses H₀: μ ≥ 600 and H_a: μ < 600 should be used because the accountant wants to test the manager's claim that the mean guest bill μ is greater than or equal to 600 and find evidence to support μ < 600.

B)The hypotheses H₀: μ ≤ 600 and H_a: μ > 600 should be used because the accountant wants to test the manager's claim that the mean guest bill μ is less than or equal to 600 and find evidence to support μ > 600.   

C)The hypotheses H₀: μ = 600 and H_a: μ ≠ 600 should be used because the accountant wants to test the manager's claim that the mean guest bill μ is equal to 600 and find evidence to support μ ≠ 600.

(b)

What conclusion is appropriate when

H₀

cannot be rejected?

A)We are able to conclude that the manager's claim is wrong. We can conclude that μ = 600.

B)We are not able to conclude that the manager's claim is wrong.We cannot conclude that μ > 600.    

C) We are not able to conclude that the manager's claim is wrong. We cannot conclude that μ ≠ 600.

D) We are able to conclude that the manager's claim is wrong. We can conclude that μ ≤ 600.

E) We are not able to conclude that the manager's claim is wrong. We can conclude that μ ≥ 600.

(c)

What conclusion is appropriate when

H₀

can be rejected?

A) We are not able to conclude that the manager's claim is wrong. We can conclude that μ < 600.

B) We are not able to conclude that the manager's claim is wrong. We can conclude that μ > 600.    

C) We are able to conclude that the manager's claim is wrong. We can conclude that μ < 600.

D)We are able to conclude that the manager's claim is wrong. We can conclude that μ ≠ 600.

E) We are able to conclude that the manager's claim is wrong. We can conclude that μ > 600.

Which of the following is not a characteristic of governmental rent controls?

A. Equitable distribution of apartments.

B. Excess demand for apartments.

C. Fewer newly built apartment buildings.

D. Very low vacancy rates.

Tourism can provide infrastructure to a region or community that may not have access to it. provide two clear example of how and why infrastructure can be improved or built to meet the needs of both tourists and locals?

Summarize the built-in security features and tools used in modern cloud infrastructures. You may select among Amazon AWS, Microsoft Azure and Google Cloud. Use internet resources to answer this question.

. An e-mail strategy, including target markets, timing, and how to incorporate branding into e-mail communications, as well as measuring tools to determine success from each platform, will also need to be built in.