Question: Write the SQL statement that lists the city and the employees sorted in the descending order of employees . Write the SQL statement that lists

Write the SQL statement that lists the city and the employees

  1. Write the SQL statement that lists the city and the employees sorted in the descending order of employees.

  1. Write the SQL statement that lists the city and the employees sorted in the ascending order of employees.

  1. Write the SQL statement that lists the branchNo, the street, the city, and the employees of branches with number of employees more than 20.

  1. Write the SQL statement that lists the branchNo, the street, and the city of branches from London or Glasgow cities.

  1. Write the SQL statement that lists the branchNo, the street, the city, and the employees of branches with number of employees between 18 and 30. Note: Use the keyword BETWEEN to accomplish this task.

  1. Similarly, using a compound comparison search condition, write the SQL statement that lists the branchNo, the street, the city, and the employees of branches with number of employees between 18 and 30. Note: Dont use the keyword BETWEEN in this task.

Consider the Branches table as follows. branchNo B005 B007 B003 B004 B002 street 22 Deer Rd 189 Hudson St 81 Shepford St 250 Fifth Ave 56 Clover Dr city London New York Glasgow New York London postcode employees SW14EH 18 10013 22 G1199x 12 10001 32 NW16EU 26 Preliminary Tasks: A. Copy and paste the following code into your SQL Editor, then execute it. This code will create the table Branches and insert the above five records into it. CREATE TABLE Branches branchNo VARCHAR(4), street VARCHAR (20), city VARCHAR(15), postcode VARCHAR(10), employees INTEGER); INSERT INTO Branches VALUES ('B005', '22 Deer Rd', 'London', 'SW14EH',18); INSERT INTO Branches VALUES ('B007', '189 Hudson St', 'New York', '10013',22); INSERT INTO Branches VALUES ('B003','81 Shepford St', 'Glasgow', 'G1199x', 12); INSERT INTO Branches VALUES ('B004', '250 Fifth Ave', 'New York', '10001',32); INSERT INTO Branches VALUES ('B002', '56 Clover Dr', 'London', 'NW16EU',26); Note: To recreate the table, you will need to drop it first by running the following command. DROP TABLE Branches; B. To make sure all records are properly inserted, list the content of the Branches table by running the following statement. SELECT * FROM Branches

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Consider the Branches table as follows. branchNo street city postcode employees B005 B007 B003 B004 B002 22 Deer Rd 189 Hudson St 81 Stepford Dr 250 Fifth Ave 56 Clover St London New York Glasgow New...

Q:

SQL Data Lab 01: SQL Data Manipulation Lab submission details are listed at the bottom of this file. Consider the Branches table as follows. branch No B005 B007 B003 B004 B002 street 22 Deer Rd 189...

Q:

Consider the Branches table as follows. branchNo street city postcode employees B005 B007 B003 B004 B002 22 Deer Rd 189 Hudson St 81 Stepford Dr 250 Fifth Ave 56 Clover St London New York Glasgow New...

Q:

Using the MySQLsakila test/sample database (available at: http://mysql-tools.com/en/downloads/mysql-databases/4-sakila-db.html) please provide SQL statements for the questions in the attached...

Q:

sql Question 13 4 Poil Assume that you have a table ABC that contains two columns: employee name e_name and the salary sal. Write a SQL statement that lists all employees' names and gives each a 15%...

Q:

Using SQL Server to create the queries below: You should copy/paste the SQL code, followed by the data/results onto this Word Document. NOTE : It is easier if you use a clipping tool for the data set...

Q:

USE Garden_Glory GO CREATE TABLE OWNER( OwnerID Int NOT NULL IDENTITY(1,1), OwnerName Char(50) NOT NULL, OwnerEmailAddress VarChar(100) NULL, OwnerType Char(12) NULL, CONSTRAINT OWNER_PK PRIMARY...

Q:

have the value Junior. Write SQL statements to insert the data into each of the five Garden Glory Database tables. Assume that any surrogate key value will be supplied by the DBMS. Use the data in...

Q:

1. Write n SQL statement to list all cities and states of vendor addresses. Make sure the result does not include duplicates. 2. Write n SQL statement to list the item ID, item description and item...

Q:

Please solve this accordingly for "Database Management System" Request: Please write the answers in a notebook (White Paper), scan the image of your notebook and upload it. Make sure your handwriting...

Q:

do the Prediction, Evidence table with descriptive title on it, Analysis and Evaluation of the Lab? Theres a checklist for guide TITLE/PROBLEM; to be written on ALL your lab reports Copied from the...

Q:

You will go about planning for your hypothetical retirement using web-based decision support systems (DSS) for financial planning and decision making. Follow the steps below and use the provided...

Q:

19. Indicate the section of an income statement in which each of the following is shown. a. Loss on inventory write-down. b. Loss from strike. c. Bad debt expense. d. Loss on disposal of a...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

2. If you were to develop a pay structure in a company where you have worked, how would you approach doing it? What are the potential challenges associated with implementing your approach?

Q:

LO5 Explain three ways in which sales employees are typically compensated.

Q:

LO3 Identify key concerns that must be addressed when designing work unit/ team variable pay plans.