Create a read-only view, name it as ViewD, that will contain RType and the number of rooms per RType in the ROOMS table.

-- 2 - Write a View to show all customer Ids that have placed orders --(Sales.SalesOrderHeader sh and Person. Person are joined on CustomerID = Business EntityID)

I am working on Task 7. Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMS, AVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms. Here is Tasks 1-7 and what I wrote for Task 8. When I input Task 8, I am not getting results at all.   Expected Results Tables_in_StayWell Table_type MONTHLY_RENTS VIEW

Use the data from the class assignment, ALTER TABLE and add two more columns Phone and email. Describe the table (show its structure) and drop the country column, describe the table (show structure). Now, create a new table based on the existing table person with the help of a subquery (The new table will contain the data from “person” table) and name the table person_self. Show its output (table created and its structure).     NOTE: Use the ALTER TABLE command with ADD clause Use the ALTER TABLE command with DROPCOLUMN clause Use the CREATE TABLE command with AS (SELECT SUBQUERY) clause

What happens to the data that was shown when a view is removed?

Create a view named NHTrips. It consists of the trip ID, trip name, start location, distance, maximum group size, type, and season for every trip located in New Hampshire (NH). Display the data in the view

In MySQL please: The Question: Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)

Create a view to show the total number of staff for each city with more than 1 staff. The output column header should be city, number_of_staff, sorted by the total number of staff from high to low.

Create a VIEW named MAJOR_CUSTOMER. It consists of the customer ID, first name, last name, balance, credit limit, and rep ID for every customer whose credit limit is $500 or less.

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.