Q1. Please write SQL codes to query data from member tables based on below criteria  Please write a SELECT statement to display each member data that street must NOT be ‘STREET’ and ‘LANE’, and valid_date CANNOT be ‘FEB’, ‘APR’, and ‘JUN’. Please display the result in descending order of the last_name. The result should be identical to below results: [SCREENSHOT]   I try to use this, but it gives me this error: SELECT MEMBER_ID, FIRST_NAME, LAST_NAME, STREET, FORMAT(VALID_DATE, 'dd-MM--yy') FROM MEMBER WHERE STREET NOT IN ('STREET', 'LANE') AND MONTH(VALID_DATE) NOT IN (2, 4, 6) ORDER BY LAST_NAME DESC;   ====== error ===== ORA-00904: "MONTH": invalid identifier ORA-00904: "FORMAT": invalid identifier

Q: SQL: Create a SQL query that uses a correlated subquery to display the descriptions for products…

A: Given to : Create a SQL query that uses a correlated subquery to display the descriptions for…

Q: Using the university schema, write an SQL query to find the number of students in each section. The…

A: SQL Query: SELECT s.course_id, s.sec_id, s.year, s.semester, count(id) AS numFROM takes t, section…

Q: write a query that displays employee last names, department numbers, and all the employees who work…

A: Here, SELECT statement is used along with the ON, WHERE, and ORDER BY clause.

Q: The Member table will have the following columns: ID—positive integer FirstName—variable-length…

A: Creating a Member Table with SQL The task is to define a SQL statement that creates a 'Member'…

Q: Write the SQL code that counts the number of assignments ordered for each project. Call this…

A: We have four tables namely: JOB PROJECT EMPLOYEE ASSIGNMENT We wish to write a query that counts…

Q: the SQL code that will create the table structure for table: PRODUCT. Note: P_CODE is the Primary…

A: SQL Code: a) Create PRODUCT table BEGIN TRANSACTION; /* Create a table called JOBS */ CREATE TABLE…

Q: Complete the following exercise: Alter your student table adding a new column called enroll_date…

A: Alter your student table adding a new column called enroll_date using the datetime data type.…

Q: ESTION Task 1: Create a VIEW named MAJOR_CUSTOMER. It consists of the customer ID, first name, last…

A: Below the Sql query for this statement

Q: Please write a SELECT statement to display each DVD title with its # of copy in the DVD table. DVD…

A: You cannot directly calculate the number of characters and to make it happen, you have to replace…

Q: Q3: How many unique titles do we have in the employee table? Hint: You need to create TWO queries,…

A: 1)   SELECT DISTINCT titles FROM EMPLOYEE

Q: Use Column level constraint setting while designing the below given table in sql named as…

A: Column constraints: In Structured Query Language, the column level constraints are used to specify…

Q: For every invoice, display the invoice number, invoice date and the total dollar amount for all…

A: Dear student  your query get the error because inv_number exist in the two table so you have to…

Q: 5) Write an SQL Query to display the accountno, name, Recurrent_acno, amount whose fixed deposit…

A: Required:

Q: . Please write SQL codes to query data from member tables based on below criteria  Please write a…

A: A number is odd number if its remainder when divided by 2 is not equal to 0

Q: Table: Employee | Column Name | Type | | id | int | | int | | salary +-- id is the primary key…

A: Given, Given Table: Employee Column Name Type id int salary int

Q: Write an appropriate SQL query to determine if there are any students that are not registered for…

A: Given: Write an appropriate SQL query to determine if there are any students that are not registered…

Q: You have been told that you need to store the zip code for employees.  Add a column to the EMPLOYEE…

A: Hello student Greetings   In this scenario, we are required to add a new column to the EMPLOYEE…

Q: Consider Following Tables. Student ( regNo, sName, sCity, sCGPA, sAge) Course ( cCode, cName,…

A: The SELECT statement in the structural query language is to retrieve one or more records from the…

Q: Using F_STAFFS table, write a query that will display First_name and maximum salary of staffs with…

A: Answer in step2

Q: True or False? The select query is not required when retrieving information.

A: We are given a statement in sql in query and we will see if it is true or not.

Q: mber in descending order and then by invoice date in ascending order. Here you will use an aggregate…

A: SQL: For every invoice, display the invoice number, invoice date and the total dollar amount for all…

Q: Insert into table customerPayment, columns customerOrderId and total result set returned from query…

A: Note: Since your question contain multiple question and having multiple sub-part but we can answer…

Q: Add a foreign key constraint to the movie table: the column prod_id is the foreign key, referencing…

A: ALTER TABLE movieADD prod_id INTEGER,ADD CONSTRAINT FOREIGN KEY(prod_id) REFERENCES production(id);

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.