Question: SQL Create a view listing all the branch location and female staff information that branch is not in Aberdeen or London and female staffs age

SQL

Create a view listing all the branch location and female staff information that branch is not in Aberdeen or London and female staffs age is older than 35. You should use Branch and Staff2 tables and the output column header name should be (branchno, city, name, age)

Branch

SQL Create a view listing all the branch location and female staff

Staff2

information that branch is not in Aberdeen or London and female staffs

| branchNo | street | city | postcode | + | B002 | 56 Cover Drive | London | NW10 6EUL | B003 | 163 Main Street | Glasgow | Gli 90X | B004 | 32 Manse Road | Bristol | BS99 INZ | B005 | 22 Deer Road | London | Swi 4EH | B007 | 16 Argyll Street | Aberdeen | AB2 3SU | staffNo | fName | iName | position sex | DOB | salary | branchNo | superno | ABCi | CCI | SAS | SG14 | SG37 | SG5 | SL21 | SL41 | XY1 | New | Enginer | Intern IM | Super | User | DBA IM | Mary | Howe | Assistant | IF | David | Ford | Supervisor | M | Ann | Beech | Assistant | F | Susan | Brand | Manager | F | John | White | Manager | M | Julie | Lee | Assistant | F | New | Tester | Assistant | 2000-01-01 | 9000.00 | B002 | 1995-01-01 | 90000.00 | B005 | 1970-02-19 | 9000.00 | B007 | 1958-03-24 | 18000.00 | B003 | 1960-11-10 | 12000.00 | B003 | 1940-06-03 | 24000.00 | B003 | 1945-10-01 | 30000.00 | B005 | 1965-06-13 | 9000.00 | B005 | 1990-01-01 | 8000.00 | B002 | SL21 | SG14 | SG5 | SGS | SG5 | SL21 | NULL | SL21 | SL21

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!

SQL Create a view listing the city and the number of female staff who has salary higher than 15000 working in the city. If the city doesnt have any working staff meet the criteria, the city should be...

D. Please implement your answers in the database CPS3740_2019S on imc.qqqq.edu server. E. You have to refer to tables Staff, Hotel, Room, Booking, Guest in database CPS3740 on imc.qqqq.edu server. F....

Language SQL I need help with this question. Create a view vHW1_6_xxxx listing the city that has only one female staff working in the city. Your out header should be (city, count). So far i have...

Article: Why Customers Stay? Reasons and Consequences of Inertia in Financial Services Abstract This research investigates inertia in a financial services context, with particular focus on the...

answer the following questions. 1. Analyze The Pub's competitive environment and macroenvironment. 2. Answer the following questions. a. What are the two most significant driving forces of change in...

2. (10 pts) Create a view vHW1_2_xxxx listing the first name, last name and salary for staff who has last name ending with 'e'. The output should be alphabetically ordered from high to low by the...

What are some of the tangible and intangible capabilities of CrossFit? Based on these capabilities, what are two core competencies? Explain how you decided these are core competencies. In which part...

Poultry Shrimp Asparagus Coconut Oil Almonds Apples Pork Lobster Avocado Olive Oil Cashews Berries Pork Chops Clams Brussel Sprouts Macadamia Oil Hazelnuts Peaches Steak Salmon Carrots Avocado Oil...

Please help with the assignment for the following attachment. FOR IMMEDIATE RELEASE 12 October 2015 Myer Holdings Limited 2015 Annual Report and Notice of Annual General Meeting Myer Holdings Limited...

Case study: Remedy Physiotherapy. I need help in drafting a marketing plan Names of people and businesses are disguised. Some aspects of the local area and the physiotherapy industry are simplified...

Gear C is rigidly attached to arm AB. If the forces and couple shown can be reduced to a single equivalent force at A, determine the equivalent force and the magnitude of the couple M. 400 400 200 N

Describe a system that employs GPS and which can reduce or eliminate ground control surveys in photogrammetry?

7. The following excerpt was taken from The Home Depot, Inc., 2021 Annual Report (for the fiscal year ended January 30, 2022): Analyze: 1. What percentage of total assets is made up of cash and cash...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

11-11 This project will give you experience using shopping bots to search online for products, find product information, and find the best prices and vendors. Select a digital camera you might want...

11-9 Canadian Tire is one of Canadas largest companies, with 50,000 employees and 1,100 stores and gas bars (gas stations) across Canada selling sports, leisure, home products, apparel, and financial...

4. Explain the law of supply. Why does the supply curve slope upward? How is the market supply curve derived from the supply curves of individual producers? LO2