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: 1. Table : ASSIGNMENT D ASSIGNMENT N NMAON DATE MM EMP MUN AiNO AlON CHO AONHOURI NON CHA 35 42 t00…

A: Explanation In SQL, the SELECT query is used to fetch or retrieve the data from the database table.…

Q: Write the T-SQL scripts for the following tasks: - Write a query to list all the Employee's details…

A: let us see the answer:- Introduction:- We are going to use a select query to list all the Employees…

Q: Create a query based on the EMP table that satisfies the criteria below Use the TO_CHAR function to…

A: Solution:   When you install Oracle 11g Enterprise Edition there are couple databases you can chose…

Q: CUSTOMER aus CODE CUS LNAME CUS FNAME CuS INITIAL CUS AREACODE CuS PHONE CUS BALANCE PRODUCT P cODE…

A: SQL (Structured Query Language) is a database query language. According to ANSI, it is the…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Write the T-SQL scripts for the following tasks:   Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: using the code belowe write a query to display the movie genre and average price rental fee for…

A: In the database analysis, understanding the distribution of movie costs across genres is a crucial…

Q: Using Pubs: USE MICROSOFT SQL SERVER Create a query listing all the books that Barnum’s purchased.…

A: I attached your answer below.

Q: n SQL When you use ALTER TABLE to add a column, the new column: Select one: a. Will not be created…

A: ANSWER : B   Becomes the last column in the table

Q: using the code below write a query to display the movie title, movie year, and movie genre for all…

A: Algorithm: Retrieve and Sort Movie Information by Genre and Year1. Create a MOVIE table with…

Q: Select one of the following: (only one please) Display painters’ details who exhibit their…

A: It is defined as the collection of information that is organized so that it can be easily accessed,…

Q: Q1) Please write. a query statement from emp table to display deptno 10’s empno, ename, sal, and a…

A: --> As new_sale is increased 15% that means it increases by 115 out of 100% which is 115/100 =…

Q: 5. Add a column to the query described in exercise 2 that uses the RANK() function to return a…

A: The above question is solved in step 2 :-

Q: The following SQL clause(s) are not permitted to be used in a subquery in the WHERE or HAVING…

A: Multicolumn subqueries cannot use the <, >, <=, >= comparison operators.

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: using the code below write a query to display the movie title, movie genre, price description, and…

A: Select Columns: Choose the columns to be displayed: MOVIE_TITLE, MOVIE_GENRE, PRICE_DESCRIPTION, and…

Q: using the code write a query to display the movie number, movie title, movie cost, and movie genre…

A: 1. Create a table named MOVIE:   - Define columns:     - MOVIE_NUM as INT (Primary Key)     -…

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.