write my sql , p/sql pr t-sql procedures to retrieve and output the item id, description, location, and price of every item in the category stored in i_category

9. Determine the number of different customers who have placed an order for books written orcowritten by James Austin. SQL commands

5. Display the current day of the week, hour, minutes, and seconds of the current date settingon the computer you’re using. SQL commands

From the Salesm an and Customer tables below, write SQL statements to do the following: a) List the sales man id, rating and names of those sales men who getrating from 3 to 5, sorted DESCENDING by rating. b) List all the customers' informat ion whose name starts with 'F' and the fourth character is T, rests may be any charac ter. c) List the name andcountry of those customers and sales men who belongs to the same country. Salesman table: Salesman Salesman_ rating _id country name 2001 Mc Lyon 3 Italy 2005 James hood 2 Canada 2045 Paul Hen USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Cust omer table: Cust_id Cust_nam grade country Salesman e _id 1 Nick 100 France 2010 Rimando 2 Brad Davis 400 Canada 2005 3 Fabian 200 Japan 2045 Johnson 4 UK Jozy Altidor 100 2010 5 Brad Guzan 500 Canada 2005

Write MySQL, PL/SQL, or T-SQL procedures to retrieve and output the item ID, description, location, and price of every item in the category stored in I_CATEGORY.

PL/SQL please use oracle sql developer. I know it would be hard to slove without the data but please help Given a start and end date, print out names, phone number, status, and flight ID of people who were on the same flight with someone whose status is 1 (tested positive) and the flight date is between the start and end date.

Write all the sql code (including create, insert and select)

QUICK SQL REQUEST (beginner level...) Back at work on Monday morning, the Vice President of Purchasing asks you to help him with the analysis of in-process storage. He asks you to pull information regarding the number of products per storage location. The result of the query should show: - The name of the warehouse (Location) - The number of different products per storage location - The total quantity of products found at this storage location - The average price of all products found at this storage location He mentions that for the moment he is only interested in the locations that have more than 50 distinct products because he wants to start inventorying the biggest locations first. Show the locations in order of smallest to largest number of distinct products. My request is linked to the question but i'm having trouble executing it I would love to know how to do it, thanks in advance.

By using this table answer this question in SQL: Show the department id, department name and the number of employees working in any department which has less than 4 employees

Need help writing SQL queries for sample data base

use sql please List only the movies that have a value for gross (not NULL values). Include all columns in the result set.

using the link below, select which data type best fits the following needs: https://www.w3schools.com/sql/sql_datatypes.asp The Date a student enrolls with a university The students phone number The name of a degree program The students financial aid amount

What are some common uses for the STRING_AGG function in SQL?