.Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as .    ii.Write an SQL query to fetch unique values of DEPARTMENT from Worker table.

1. Write an SQL query to find all customers whose name (either last name or first name) contains “brown”. (Make sure the search is case insensitive.) 2. Write the SQL query to update all products’ discount per cents to 25% whose prices are more than $2000. Also, update the dateAdded field with the current date

Write and execute a SQL query to list all patient numbers and encounter ids which do not have any data (missing rows) in VisitSummary table. Order the result by patient number, encounter id.      Write and execute a SQL query to list all patients whose information about race or gender has changed during their future visits. A future visit is defined as T1.encounter_id < T2.encounter_id.  Your output should have patient number, old and new race values, old and new gender values, and the encounter ids.   Write and execute a SQL query to list all the patient data for all encounters. Even if patient data is missing in other tables, you still need to list the patient_nbr and encounter_id in your output. Your output should list all the columns (without repeating them) starting with encounter_id, patient_nbr... and it should be ordered by patient_nbr and then encounter_id.    Write and execute a SQL query to list all the patient data for all encounters. If the patient data is missing…

How can the CAST function be combined with other functions to enhance data type compatibility in SQL queries?

Create a function to increment the salary of employees of an organization by 15%, and for employees with department ID 100 give another 10% hike on the updated salary. Also, write the query to update the salary of all records of the salary column in the employee table using the created function. In PL/SQL

Write an SQL query that will show all data from the Customers table andOrder By State.

Write an SQL query using the NOT operator that will show all employeeinformation from the Employee table with the exception of EmployeeNumber 7344.

Problem 9 Write a query to count the number of invoices.

4) Display the firstname, lastname of the employees and the customerID that the employee served. Arrange the results by the last name. 5) Write a query to the Name of the Product and the corresponding name of the supplier of that Product for all the products that start with a “P”. 6) Write a SQL query to output the product name and the quantity of the Orders of that product for those orders with more than 70 quantity. (hint: don’t have to use GROUP BY)   I need help figuring out the SQL quereys for the questions above using table joining method

Write a query in SQL code for: "List the book categories and the average book price of each category."  Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY