MySql Workbench CREATE TABLE students (  id INT PRIMARY KEY,  first_name VARCHAR(50),  last_name VARCHAR(50),  age INT,  major VARCHAR(50),  faculty VARCHAR(50)); CREATE TABLE location (  id INT PRIMARY KEY,  name VARCHAR(50),  rooms INT); CREATE TABLE faculty (  id INT PRIMARY KEY,  name VARCHAR(50),  department_id INT); 1. List last name of all students whose first name is longer than 4 letters in ascending order accordingto the last name. Duplicated rows should be removed from the output.2. Count the total number of rooms in Location.3. Find the number of students in each major.4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...

Apex, Salesforce In which you have two types of Record type on Position Object one is for Technical and one is non technical Record type. you have to write a SOQL query to fetch All the reocrd type of the ID of Technical Record Type. Please Run the SOQL Query on the Anonymous Window. also please attach the screenshot of the output.

15. Open the AttendeeFirstName query in Design View and add criteria to select only those records where the FirstName field value begins with Lau followed by any other letters. Save the changes to the query. Open the query in Datasheet View, confirm that two records appear in the query results, and then close it.

CREATE TABLE Users( C_Id varchar(8) NOT NULL, LastName Varchar(255) NOT NULL, FirstName varchar(255) NOT NULL, ema il varchar(255), Phone int, PRIMARY KÉY (C_Id) CREATE TABLE Restaurants( R_Id varchar(255) NOT NULL, Rname varchar(255) NOT NULL, Type varchar(255), Raddress varchar(255), Rphone int, Remail varchar(255), PRIMARY KEY(R_Id) ); CREATE TABLE RDate( T_num int NOT NULL, Bdate DATE, Rdate DATE, T_start varchar(255), E_start varchar(255), PRIMARY KEY(T_num) ); CREATE TABLE Book ingInfo( C_Id varchar(8) NOT NULL, R_Id int NOT NÚLL, PRIMARY KEY(C_Id, R_Id), FOREIGN KEY (C_Ià) REFERENCES Users(C Id), FOREIGN KEY (R_Id) REFERENCES Restaurant(R_Id) ); CREATE TABLE Rating( R_Id varchar(255) NÓT NULL, Rating Id varchar(255) NOT NULL, Rate varchar(255) CHECK (Rate>11), Comment LONG, PRIMARY KEY(Rating Id), FOREIGN KEY (R_Id) REFERENCES Restaurants(R_Id) ); Create 1 procedure Create 1 function Create 1 database trigger |

CREATE OR REPLACE VIEW view_name ASSELECT column1, column2, ...FROM table_nameWHERE condition; in oracle  the  Drop view DROP VIEW view_name;

Views: Create a view “customer_guangzhou”, it indicates the customers from the city “guangzhou”; Create a view “ordersum_goods”, it indicates the total quantity of the orders of each product (goods).

Add a new row in the ORDERS table with the following data: Order# = 1023 and Customer# = 1009. Describe the error raised and what caused the error.

The SERVICE_REQUEST table uses the CHAR data type for the DESCRIPTION and STATUS fields. Is there an alternate data type that could be used to store the values in these fields? Justify your reason for choosing an alternate data type or for leaving the data type as CHAR.

Add a new row in the ORDERS table with the following data: Order# = 1022, Customer# = 2000, and Order date = August 6, 2009. Describe the error raised and what caused the error.