Select employee first name, concatenate it with job, find length of department id, find location of ‘a’ in employee first name column.

In the BOOK_PRICING database, the Category field should be marked as obsolete. Make sure the column has been marked as unavailable.

List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.

Display manager ID and number of employees managed bythe manager. using sql plus hr user

Create a report of employees within the Research department showing First Name, Last Name, sorted alphabetically A-Z.

8) Create a query for displaying list of employees who joined in the second half of year ‘07’;

SQL BITS List client number, balance, consultant number, and consultant last name of every client whose balance is greater than that of client number '405.'

List the number of albums for each artist. Only include artists with more than 5 albums. table of database Artist (ArtistId, Name) Album (AlbumId, Title, ArtistId, Year) Track (TrackId, Name, AlbumId, ArtistId, GenreId, Year) Genre (GenreId, Name)

7. List the shipping city and state for the order that had the longest shipping delay. SQL commands

Add a foreign key constraint to the movie table: the column prod_id is the foreign key, referencing the column id from the production table (use sql) following is movie and production table