You need to run SELECT query and return all travel data from TRAVELS table filtered by the drivers who has lower rating than 4 in the DRIVERS table.

Import the ticket transaction data set and what teams (besides Washington Capitals) and what seat types are inside the data set? Clean the transaction data and only keep the ticket transactions of Washington Capitals in the CB/LC/LG/MC/MG seat zones. How many ticket transactions remain after data cleaning? and the dates of the two games?

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).

Delete an employee having ID = 203 (e.g.) Commit changes if that employee’s manager id = 105 Otherwise rollback all the changes. Use Employees table.