In order to freeze the panes for both the row and first column of the worksheet, which cells, rows or columns should you select? C 1 2015 - 2018 Enrolment Data Name Gender Mail address Department Enrolment date 4/12/15 12/2/15 2/23/16 5/5/18 3 AALIYAH Butler AButler@kennesaw.student.edu AHill@kennesaw.student.edu F Psychology Psychology Finance 4 AALIYAH Hill 5 AARON Murphy AMurphy@kennesaw.student.edu AClark@kennesaw.student.edu ARamirez@kennesaw.student.edu AThomas@kennesaw.student.edu ABailey@kennesaw.student.edu ABaker@kennesaw.student.edu AEdwards@kennesaw.student.edu AGonzales@kennesaw.student.edu AGreen@kennesaw.student.edu AGriffin@kennesaw.student.edu AMoore@kennesaw.student.edu M 6 ABIGAIL Clark Finance 7 ABIGAIL Ramirez 8 ABIGAIL Thomas Economics Management Management Psychology Finance 7/2/16 2/28/18 10/10/16 8/1/16 9 ADA Bailey 10 ADA Baker 11 ADA Edwards 8/2/16 5/6/18 7/10/16 9/20/17 F 12 ADA Gonzales Psychology Psychology Economics 13 ADA Green 14 ADA Griffin 15 ADA Moore |Management 10/18/17

Lalal Module Lab Assessment 3 دارد Y O Tasks for properties where their PROPERTY_ID equals 1 using the COLOMBIA_CITY_PROPERT Y VIEW Remove the ... Alter the PROPERTY table by changing the OWNER_NUM field to refer to the OWNER table. Retrieve the first and last names of the residents combined and converted to uppercase, > > Submit 12% FILETREE ⇒-/worksp Drop query. query

Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT.   ANSWER IN MYSQL PLEASE

SQL Help The Car Maintenance team wants to learn how many times each car is used in every month and day to organize their maintenance schedules. The team wants a table with the following column names and information: Car ID Month Day Count You need to create a summary table using the WITH ROLLUP modifier and grouped by the specific column names, listed above, and send the data back to the team. Query the frequency of each car's use by month and day

Refer to the dimension tables and EmployeeFact table below. Job Date Location EmployeeFact •JobID •DatelD •LocationID • ( OEmployeelD Title FullDate StreetAddress oJobID JobCode DayNumber City PostalCode OLocationID LevelCode MonthNumber oHireDatelD OBirthDatelD ) SalaryAmount BonusAmount MonthName State Year CountryCode EducationYears PerformanceRating The following query reports the employee with the highest salary amount per postal code for employees with level code 8. Complete the missing values. SELECT CountryCode, EmployeeID, MAX(_ _(A)_ FROM (B). Location, Job WHERE EmployeeFact.LocationID = Location.LocationID AND EmployeeFact.JobID = (C). AND = 8 GROUP (A) Ex: Identifier (B) (C)

question 6 use the picture below to answer the following question Add a ZIP field/column to the customer table.

Task 2: StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.

Q1Create a view named v_Title_Unavailable.The view should show the movie titles and media_id of the media not returned yet. The view should not allow any DML operationsQ2Create a SYNONYM for v_Title_Unavailable named vTU.Q3Write SQL to query the view using the synonym.

Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.

Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.