Customer (CID, CName, Street, City, State, Gender) Agent (AgentID, GName, Position, Salary, Gender, BranchNo) Invoice(InvoiceNo, CID, AgentID, Product, Quantity, Total_amt) List all cities and states for all the customers. Make sure all the cities are unique. Sort the listing by states and by cities within the state.

Customer (CID, CName, Street, City, State, Gender) Agent (AgentID, GName, Position, Salary, Gender, BranchNo) Invoice(InvoiceNo, CID, AgentID, Product, Quantity, Total_amt) List all cities and states for all the customers. Make sure all the cities are unique. Sort the listing by states and by cities within the state.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter6: Managing Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 1.16CP

See similar textbooks

Similar questions

2- selects the order line items (orderNumber, orderlinenumber) fromthe “orderdetails” table. Also, display the subtotal (quantityOrdered * priceEach) for eachline item and sorts the result set based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantityordered (itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition“total” greater than 1000.8- Display product code, product name and text description for product.9- Find customer number, customer name, order status and order number, for customerwith their orders…
This is data base question. Schema is also uploaded. 1. Show all the movie names with their type names for those movies which has been released during 2000 to 2009. (Use inner join) 2. Show the customer names along with the movie names for which they booked more than 5 seats. (Use inner join) 3. Show the Name of Staff members and their designation who did some booking for the movie ‘Avengers’. (Use inner join) 4. Show the name of movies which were released in both 2D and 3D. (Use Natural join) 5. Show names of all movies along with the staff names who did booking for them. Show all movie names whether they have been booked by any staff or not. (Use Outer Join) 6. Show all category names along with the movie names that lie in the category. Show all categories whether any movie is there of that category or not. (Use Outer Join) 7. Show all customer names along with movie names they booked. Show all the customer names whether they booked any move or not. Also show all movie names whether…
4.9 LAB - Select employees and managers with inner join The Employee table has the following columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string ManagerID - integer Write a SELECT statement to show a list of all employees' first names and their managers' first names. List only employees that have a manager. Order the results by Employee first name. Use aliases to give the result columns distinctly different names, like "Employee" and "Manager". Hint: Join the Employee table to itself using INNER JOIN.
1- List all the users and their card name using union2- List all the users and their card name using Intersection 3- List all the card numbers with owner names and scheduled transactions, in case the user hasnever used scheduled transaction show null or zero in the transaction column. (Hint use ISNULLfunction)
Student(Stud_Id, name, addr, sex, DOB, country , major) Lecturer(Lect_id, name, sex, department, tel_no) Course(Course_code, description, credit_hr, department) Registration(Stud_id, course_code, room_no, lect_id, time) Write the correct relational algebra for the following queries: Display student id, name and sex for all male students from the country of ‘Singapore’. Display student id, name, and major for all students that majoring in ‘CS’ or ‘ENG’. Display detail registration listing for courses that have more than 3 credit hours. Display student name and course description for all students taking courses offered by ‘IS’ department.
(1) for each Customer (e.g., customer C), display all other customers who have higher salary than this Customer (e.g., customer C). (use inner join, display each customer’s ID, name, and all higher salaries, you don’t need to display information about the customers who have higher salary.) (2) for each Customer (e.g., customer C), display all other customers who have higher salary and are younger than this Customer (e.g., customer C).
Create a view of the Join of Deposit and Withdraw transactions to Bank Branch UNION with the join of Bill Payment and Debit Purchase, or Return transactions to Merchant (i.e., all transactions with appropriate reference name.). BranchNbr stores RefNbr of either 'D', OR 'W' transactions, and MerchantNbr stores RefNbr of either 'B', 'P' or 'R' transactions. List of only the Accounts that have multiple Clients associated Provide a count and total amount of Transactions for each Type Description PLEASE DONT NOT COPY THE EXISTING SOLUTION ON BARTLEBY IT IS WRONG AND DOES NOT WORK AND INCOMPLETE. GIVEN THE BELOW: --THIS CREATES THE BANK BRANCH TABLE: CREATE TABLE BankBranch ( BranchNbr INT PRIMARY KEY, BranchName VARCHAR(250)); --THIS CREATES THE MERCHANT TABLE: CREATE TABLE Merchant ( MerchantNbr INT PRIMARY KEY, MerchantName VARCHAR(250)); --THIS CREATES THE TRANSACTION TABLE: CREATE TABLE Transaction ( TxNbr INT PRIMARY KEY, AccountNbr INT,…
Create a view of the Join of Deposit and Withdraw transactions to Bank Branch UNION with the join of Bill Payment and Debit Purchase, or Return transactions to Merchant (i.e., all transactions with appropriate reference name.). BranchNbr stores RefNbr of either 'D', OR 'W' transactions, and MerchantNbr stores RefNbr of either 'B', 'P' or 'R' transactions. List of only the Accounts that have multiple Clients associated Provide a count and total amount of Transactions for each Type Description PLEASE DONT NOT COPY THE EXISTING SOLUTION ON BARTLEBY IT IS WRONG AND DOES NOT WORK AND IS INCOMPLETE. GIVEN THE BELOW: --THIS CREATES THE BANK BRANCH TABLE: CREATE TABLE BankBranch ( BranchNbr INT PRIMARY KEY, BranchName VARCHAR(250)); --THIS CREATES THE MERCHANT TABLE: CREATE TABLE Merchant ( MerchantNbr INT PRIMARY KEY, MerchantName VARCHAR(250)); --THIS CREATES THE TRANSACTION TABLE: CREATE TABLE Transaction ( TxNbr INT PRIMARY KEY, AccountNbr INT,…
Q#1 Insert two records in each table or use if you have already created this schema.Q#2 Display Employees Fname and salary who are males and salary is greater than equal to1000.Q#3 Display Address of employees where salary range starting from 1000 to 2000.Q#4 Display Last name of employee that starts with A and end on B.Q#5 Display Fname of employee that starts with A and have size of 3. Like: Ali,Ans etcQ#6 Display Project name and Project number that belongs to department 1.Q#7 Display Dependent name who were not born in 2002,2003 and 2004.Q#8 Display Pno who take a time more than 3 hours and less than 10 hours.Q#9 update working hours 3 hours to 5 hours.Q#10 Delete record in Dependent who have gender Male.
Hello, Can you please assist me with this? -- 7. Using Boolean operators (AND, OR) and comparison operators (=, >, <, >=, <=,!=), write a query to display details for employees-- That work in the Sales or Marketing departments (DEPARTMENT_IDs 20 and80)-- AND have a salary greatee tham or equal to $5,000 and less than orequal to $10,000.-- Sort the results by salary (descending) and employees’ last names and firstnames.-- 8. Rewrite the query in the previous question using the operators IN andBETWEEN.-- 9. Using IN, write a query to display-- The names and job IDs of the employees-- In the sales and marketing departments (DEPARTMENT_IDs 20 and 80).-- Sort the results by department and the employees’ last and first names.-- 10. Rewrite the query in the previous question to find the employees in theother departments by adding JUST ONE WORD to that query
Q#1 Print the name of players who played any tournament organized by “hafiz asif”. (Nested Queries)Q#2 Print the sponsors name and tournament name where sponsor name starts with “a”. (Inner Join)Q#3 Print the rank code of the tournament name “grand master”.Q#4 Find and display what type of rank players played in a tournament organized by omer khalid.Q#5 Print the name of the players and email who have started matches in 2002,2003 and 2004.(Nested queries
Please I want the EER or E-R Digram for this question: A patient is identified by patient id, and admission date. • A patient must be either an Emergency patient or a resident patient. • We must record the checkback date for Emergency patient. • Only resident patient is assigned to one room. Room has a unique number, degree, and floor number. • For each room there are a number of beds each of which has a bed number, specification. If a room is deleted, you need not keep track of its beds any longer. • Both emergency patient and resident are cared for by a responsible Doctor. Doctor is identified by Doctor number. For each Doctor, the name, several specialty, and years of experience must be recorded. • Doctors prescribe medicine for patients. Medicine is identified by trade name that has scientific name and formula. The medicine depends on another medicine to be taking before. • A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions…