Display user name and their city who have booked their tickets not by using HDFC bank for any of the bookings. Sort the result based on user name. SQL Code Required BUSES number(11) BUS_NO BUS_NAME varchar2(20) t TYPE SCHEDULE varchar2(3) date d varchar2(20) t DESTINATION varchar2(20) t number(11) number(11) # varchar2(20)t PSCHEDULE_ID TRAVEL DATE TOTAL_SEATS number(11) # AVAIL_SEATS number(11) # SOURCE BUS NO O BUS_NO DURATION PAYMENTS DISCOUNTS varchar2(3) PAYMENT_ID varchar2(3) t varchar2(3) number(11) O DISCOUNT_ID varchar2(3) DISCOUNT_ID DISCOUNT_AMOUNT number(11) # TICKET ID BD ID O TICKET_ID OEO BD_ID TICKETS DISCOUNT_ID

Q: Write SQL command that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each…

A: The sql query is solved in step2

Q: sql query

A: Here have to determine about SQL query for given scenario.

Q: Report the name of the customer who bought the most expensive product. sql

A: According to the information given:- We have to write query  in order to get the name of the…

Q: CUSTOMER aus CODE CUS LNAME CUS FNAME CuS INITIAL CUS AREACODE CuS PHONE CUS BALANCE PRODUCT P cODE…

A: SQL (Structured Query Language) is a database query language. According to ANSI, it is the…

Q: List the order number and order date for every order that was placed by Mary Nelson and that…

A: SQL, or Structured Query Language, is a programming language designed for managing and manipulating…

Q: Write SQL code that will return the total number of hours worked for each employee and the total…

A: Assignment: An assignment is a task that you have been given by someone in authority. The term…

Q: Write the SQL query to find all the place whose temperature is 38. SELECT place WHERE temperature…

A:

Q: Select FirstName,LastName,department,project_name,hours from employeetab,Project where…

A: This SQL code aims to select certain columns from two tables, employeetab and Project, join them…

Q: Write the SQL code to add sample data (1 row for each table).

A: Insertion into table USERS:- INSERT INTO USERS(USER_ID, USER_NAME, USER_TYPE, USER-LIMIT) VALUES…

Q: display the doctor has referred any patients to have a blood sugar test performed or not. If the…

A: Question: Create a query that displays the Doctor_ID, Doctor_Surname, and whether or not the doctor…

Q: Print out names, phone numbers, house ID, and status of people who live in the same house as anyone…

A: Database: A database acts as a storage of data. A large amount of data is being stored in the…

Q: Write a query to display maximum bus tickets fare and give an alias name as MAXIMUM_AMOUNT

A: We use SELECT statement for selecting the data from relational database, the result will be stored…

Q: Write the SQL code to list the customer ID, first name, last name, street, city, state, zip and the…

A: SQL stands for Structured Query Language. It is a standard programming language designed for…

Q: salary is above 4000 and job_id starts with a letter “S”

A: 1. SELECT * FROM employee WHERE (salary > 4000) AND job_id LIKE 'S%'   2. SELECT              *,…

Q: Insert the following records into the tables LIBRARY and MEMBER Table: LIBRARY Вook_Type ok_ID |…

A: INSERT statement inserts records to a table by mentioning the column names and respective values of…

Q: Write an SQL query using the IN operator to show all customers residingin the following zip codes:…

A: As the database is not given we have assumed the database CUSTOMERS. SQL query to create table…