I am trying to find the average of data and Floor the results. How would you use AVG and FLOOR function together?

SQL- StayWell’s maintenance team is working on the staffing plan for the month of November 2019 including number of people required in the upcoming month. They need all the service requests with the category of Plumbing (category number 1) and Heating (category number 2), and the next service date within November 2019. You need to collect this information from service requests and send it to the team. To use BETWEEN condition with dates, do not forget to use the CAST function to convert the values to dates such as CAST('2019-01-01' AS DATE).

How to create a query in SQL developer (oracle) to: Display Department_id, Job_id, the Average salary for this combination under alias Average Dept/Job Pay and the Lowest salary for this combination as well under alias Lowest Dept/Job Pay, but only if that Lowest Pay falls in the range $5000 - $15000. Exclude Vice Presidents from this query and departments IT and SALES as well. Sort the output according to the Department_id and then by Job_id. You need to use only the Subquery method (NO joins allowed).

Write an SQL query using the AND operator that show all orders shoppedon April 1, 2009 shipped to the state of Florida

Several new built-in operations are available in SQL;2008. To simplify, just enumerate the four (4) applications.

How do you compose a subquery in SQL where you are searching for the most common value in one column for a specific value from another column (i.e. looking for the down where most penalties occur --> down is a column and PlayType is a column with penalties as a value). The columns are in the same table.

How can the DATEDIFF function be used to calculate the time difference between two dates in SQL?

In what situations might the SOUNDEX function be useful in SQL when querying text data?

By using this table answer this question in SQL : Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table.  If an employee does not belong to a department, then their department number and department name should show as “N/A” and their department city should show up as  “No City info Found”.  MAKE SURE you have all the employees displayed including the employees who do not have a department.

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