List the vendor names and address for all the vendors who have active invoices. And the invoice total is not less than 800 (Hint: vendors, active invoices tables) WHERE V.VENDOR_ID = AI.VENDOR_ID AND INVOICE_TOTAL>=800; %3D

Based on table below, using oracle: used subqueries,display the supplier that supplied the most computers. CREATE TABLE supplier(SuppID NUMBER(3),SName VARCHAR2(15),SAddress VARCHAR2(20),SPhone VARCHAR2(12),CONSTRAINT supplier_suppID_PK PRIMARY KEY (suppID)); CREATE TABLE location(LocID NUMBER(3),Bldg_code CHAR(4),RoomNo NUMBER(3),CONSTRAINT location_locid_PK PRIMARY KEY (LocID)); CREATE TABLE computer(CompID NUMBER(5),SNumber VARCHAR2(15),Make VARCHAR2(20),SuppID NUMBER(3),LocID NUMBER(3),Value NUMBER(6,2),Date_purchased DATE,CONSTRAINT computer_compID_PK PRIMARY KEY (compID),CONSTRAINT computer_suppID_FK FOREIGN KEY (suppID) REFERENCES supplier,CONSTRAINT computer_locID_FK FOREIGN KEY (locID) REFERENCES location); INSERT INTO supplier VALUES (122, 'Compaq Sdn.Bhd', '10 Jalan Duta', '03-989898');INSERT INTO supplier VALUES (123, 'ASUS Sdn.Bhd', '12 Jalan Duta', '03-232323');INSERT INTO supplier VALUES (124, 'IBM Sdn.Bhd', '15 Jalan Duta', '03-565656');INSERT INTO supplier VALUES (125,…

The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.

List the names of all customers that have a credit limit of $7,500 or less

Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.

List all vendors with their address(city, state,zipcode) for all the vendors who have credited account (credit total>0)) Hint:Vendors & Invoices tables with credit total column WHERE vendors.vendor id = invoices.vendor id AND CREDIT_TOTAL>0; %3D

Write a SQL query to find the customer# of those customers that purchased at least once in July 2020 but NOT in August 2020. In addition to the customer#, show the ISBN and title of the book(s) they purchased in July 2020. You may use only one query. No creating any temporary tables or subqueries. You may use only joins. SUBMIT a second solution in addition to your Level 1.

Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table. Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS. Write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The result is shown as below.

query no 2 is select avg(CustBal) from Customer where CusState='WA' GROUP BY city. Here aggregate function avg is used to calculate average of customer balance.next where statement is used to filter the customer who live in Washington state and at last group by clause is used to show the balance city wise.

Write SQL CODE List all the Course Code (CRS_CODE) that are taught by a Professor that does not hold "Ph.D." as the highest degree (based on PROF_HIGH_DEGREE in the PROFESSOR table).