Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Just gotta create SQL codes out of the data inputted in the images, help please! Display all data from propertyrent table Display client comments from viewing about rental properties. Display available job position of staffs

Just gotta create SQL codes out of the data inputted in the images, help please! Display all data from propertyrent table Display client comments from viewing about rental properties. Display available job position of staffs

Microsoft Windows 10 Comprehensive 2019
Microsoft Windows 10 Comprehensive 2019
1st Edition
ISBN:9780357392607
Author:FREUND
Publisher:FREUND
Chapter7: Microsoft Edge
Section: Chapter Questions
Problem 1EYK
See similar textbooks
icon
Related questions
Question

Just gotta create SQL codes out of the data inputted in the images, help please!

  • Display all data from propertyrent table
  • Display client comments from viewing about rental properties.
  • Display available job position of staffs
  • Display the information (name, position, salary) about a person who earns the highest salary.
  • Display the number of staff grouped by branch.
  • Display each branchID with the number of rental properties grouped by branch.
  • Display each staffID n with the number of rental properties grouped by staff.
  • Display the rental property located Glasgow
  • Display ownerID who owns the rental property 'PA14'.
  • Display the most frequently viewed property.
  • Display available(possible) rental prices
  • Display the name of client who were looks for "House"
  •  
  • *** Multiple tables
  • Display branch information (city) with the number of rental properties grouped by branch.
  • Display staff information (name, position, branchID, Brach City) with the number of rental properties grouped by staff.
  • Display owner information (name, address, etc.) who owns the rental property 'PL94'.
  • Display the number of rental properties group by the type
  • List staff information who works at London.
Viewing Client Branch PropertyNO, ClientNo (k) PK ClientNo BranchNo Works at PropertyRent PropertyNo Staff BrachNo, StaffNo, OwnerNo (fk) StaffNo BranchNo (fk) privateOwner PK OwnerNo
Transcribed Image Text:Viewing Client Branch PropertyNO, ClientNo (k) PK ClientNo BranchNo Works at PropertyRent PropertyNo Staff BrachNo, StaffNo, OwnerNo (fk) StaffNo BranchNo (fk) privateOwner PK OwnerNo
Photos - ITEC315LABO5PrivateOwnerTable.png Photos - ITEC315LABO5Viewing Table.png Photos - ITEC315LABO5Branch Table.png Photos - ITEC315LABO5ClientTable.png + + + 女 X。 Table: I VIEWING CLIENTNO PROPERTYNO VIEWDATE COMMENTS Table: BRANCH Table: PRIVATEOWNER Filter Filter Filter Filter Table: CLIENT 1 CR56 PA14 24-May-04 too small BRANCHNO STREET CITY POSTCODE OWNERNO FNAME LANME ADDRESS TELNO CLIENTNO FNAME LNAME TELNO PREFTYPE MAXRENT Filter Filter Filter Filter 2 CR62 PA14 14-May-04 no dining room Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter 3 CR56 26-May-04 NULL 1 BO05 22 Deer Rd London Sw1 4EH 1 C046 Joe Keogh 2 Fergus Dr. Aberdeen AB2 7Sx 012-234-5938 PG4 1 CR76 John Kay 123-345-7891 Flat 425 4 CR56 28-Apr-04 NULL 2 B007 16 Argyll St Aberdeen AB1 3SU PG36 2 C087 Carol Farrel 6 Array St. Glasgow G32 9DX 231-456-2222 2 CR56 Aline Stewart 213-344-7234 Flat 350 5 CR62 20-Apr-04 too remote 3 B003 163 Main St Glasgow G11 9QX PG4 3 C040 Tina Murphy 63 Well St. Glasgow G42 231-234-3478 3 CR74 Mike Ritchie 345-123-7234 House 750 4 B004 32 Manse Rd Bristol BS99 1NZ 4 C093 Tony Shaw 12 Park Pl. Glasgow G4 0QR 231-678-8648 4 CR62 Mary Tregear 01224-196720 Flat 600 5 B002 56 Clover Dr London NW10 6EU Photos - ITEC315LABO5StaffTable.png C315LABO5PropertyRentTable.png + Add to + hotos 4140 urose, Keith Ross Ba Filter in any column ON Table: PROPERTYRENT Table: STAFF ba Filter PROPERTYNO STREET CITY POSTCODE TYPE ROOMS RENT OWNERNO STAFFNO BRANCHNO STAFFNO FNAME LNAME POSITION SEX DOB SALARY BRANCHNO Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Section: Ch... Filter Filter Filter Filter 1 PA14 16 Holland Aberdeen AB1 5SU House 6 650 CO46 SA9 BO07 |1 SL21 John White Manager M 1-Oct-45 30000 BO05 2 PL94 6 Argyll St London NW2 Flat 4 400 C087 SL41 B005 2 SG37 Ann Birch Assistant F 10-Nov-60 12000 B003 he difference... 3 PG4 6 Lawrence St Glasgow G11 9QX Flat 350 C040 NULL B003 3 SG14 David Ford Supervisor M 23-Mar-58 18000 вооз 4 PG36 2 Manor Rd Glasgow G32 4QX Flat 3 375 C093 SG37 B003 4 SA9 Mary Howe Assistant 19-Feb-70 9000 B007 5 PG21 18 Dale Rd Glasgow G12 ar books House 5 600 C087 SG37 B003 5 SG5 Susan Brand Manager F 3-Jun-40 24000 B003 6 PG16 5 Novar Dr Glasgow G12 9AX Flat 450 C093 SG14 BO03 6 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 your !! of +
Transcribed Image Text:Photos - ITEC315LABO5PrivateOwnerTable.png Photos - ITEC315LABO5Viewing Table.png Photos - ITEC315LABO5Branch Table.png Photos - ITEC315LABO5ClientTable.png + + + 女 X。 Table: I VIEWING CLIENTNO PROPERTYNO VIEWDATE COMMENTS Table: BRANCH Table: PRIVATEOWNER Filter Filter Filter Filter Table: CLIENT 1 CR56 PA14 24-May-04 too small BRANCHNO STREET CITY POSTCODE OWNERNO FNAME LANME ADDRESS TELNO CLIENTNO FNAME LNAME TELNO PREFTYPE MAXRENT Filter Filter Filter Filter 2 CR62 PA14 14-May-04 no dining room Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter 3 CR56 26-May-04 NULL 1 BO05 22 Deer Rd London Sw1 4EH 1 C046 Joe Keogh 2 Fergus Dr. Aberdeen AB2 7Sx 012-234-5938 PG4 1 CR76 John Kay 123-345-7891 Flat 425 4 CR56 28-Apr-04 NULL 2 B007 16 Argyll St Aberdeen AB1 3SU PG36 2 C087 Carol Farrel 6 Array St. Glasgow G32 9DX 231-456-2222 2 CR56 Aline Stewart 213-344-7234 Flat 350 5 CR62 20-Apr-04 too remote 3 B003 163 Main St Glasgow G11 9QX PG4 3 C040 Tina Murphy 63 Well St. Glasgow G42 231-234-3478 3 CR74 Mike Ritchie 345-123-7234 House 750 4 B004 32 Manse Rd Bristol BS99 1NZ 4 C093 Tony Shaw 12 Park Pl. Glasgow G4 0QR 231-678-8648 4 CR62 Mary Tregear 01224-196720 Flat 600 5 B002 56 Clover Dr London NW10 6EU Photos - ITEC315LABO5StaffTable.png C315LABO5PropertyRentTable.png + Add to + hotos 4140 urose, Keith Ross Ba Filter in any column ON Table: PROPERTYRENT Table: STAFF ba Filter PROPERTYNO STREET CITY POSTCODE TYPE ROOMS RENT OWNERNO STAFFNO BRANCHNO STAFFNO FNAME LNAME POSITION SEX DOB SALARY BRANCHNO Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Section: Ch... Filter Filter Filter Filter 1 PA14 16 Holland Aberdeen AB1 5SU House 6 650 CO46 SA9 BO07 |1 SL21 John White Manager M 1-Oct-45 30000 BO05 2 PL94 6 Argyll St London NW2 Flat 4 400 C087 SL41 B005 2 SG37 Ann Birch Assistant F 10-Nov-60 12000 B003 he difference... 3 PG4 6 Lawrence St Glasgow G11 9QX Flat 350 C040 NULL B003 3 SG14 David Ford Supervisor M 23-Mar-58 18000 вооз 4 PG36 2 Manor Rd Glasgow G32 4QX Flat 3 375 C093 SG37 B003 4 SA9 Mary Howe Assistant 19-Feb-70 9000 B007 5 PG21 18 Dale Rd Glasgow G12 ar books House 5 600 C087 SG37 B003 5 SG5 Susan Brand Manager F 3-Jun-40 24000 B003 6 PG16 5 Novar Dr Glasgow G12 9AX Flat 450 C093 SG14 BO03 6 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 your !! of +
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

         * Single tables

  • Display the information (name, position, salary) about a person who earns the highest salary.
  • Display the number of staff grouped by branch.
  • Display each branchID with the number of rental properties grouped by branch.
  • Display each staffID n with the number of rental properties grouped by staff.
  • Display the rental property located Glasgow
  • Display ownerID who owns the rental property 'PA14'.
  • Display the most frequently viewed property.
  • Display available(possible) rental prices
  • Display the name of client who were looks for "House"

    * Multiple tables
  • Display branch information (city) with the number of rental properties grouped by branch.
  • Display staff information (name, position, branchID, Brach City) with the number of rental properties grouped by staff.
  • Display owner information (name, address, etc.) who owns the rental property 'PL94'.
  • Display the number of rental properties group by the type
  • List staff information who works at London. 
Viewing Client Branch PropertyNO, ClientNo (k) PK ClientNo BranchNo Works at PropertyRent PropertyNo Staff BrachNo, StaffNo, OwnerNo (fk) StaffNo BranchNo (fk) privateOwner PK OwnerNo
Transcribed Image Text:Viewing Client Branch PropertyNO, ClientNo (k) PK ClientNo BranchNo Works at PropertyRent PropertyNo Staff BrachNo, StaffNo, OwnerNo (fk) StaffNo BranchNo (fk) privateOwner PK OwnerNo
Photos - ITEC315LABO5PrivateOwnerTable.png Photos - ITEC315LABO5Viewing Table.png Photos - ITEC315LABO5Branch Table.png Photos - ITEC315LABO5ClientTable.png + + + 女 X。 Table: I VIEWING CLIENTNO PROPERTYNO VIEWDATE COMMENTS Table: BRANCH Table: PRIVATEOWNER Filter Filter Filter Filter Table: CLIENT 1 CR56 PA14 24-May-04 too small BRANCHNO STREET CITY POSTCODE OWNERNO FNAME LANME ADDRESS TELNO CLIENTNO FNAME LNAME TELNO PREFTYPE MAXRENT Filter Filter Filter Filter 2 CR62 PA14 14-May-04 no dining room Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter 3 CR56 26-May-04 NULL 1 BO05 22 Deer Rd London Sw1 4EH 1 C046 Joe Keogh 2 Fergus Dr. Aberdeen AB2 7Sx 012-234-5938 PG4 1 CR76 John Kay 123-345-7891 Flat 425 4 CR56 28-Apr-04 NULL 2 B007 16 Argyll St Aberdeen AB1 3SU PG36 2 C087 Carol Farrel 6 Array St. Glasgow G32 9DX 231-456-2222 2 CR56 Aline Stewart 213-344-7234 Flat 350 5 CR62 20-Apr-04 too remote 3 B003 163 Main St Glasgow G11 9QX PG4 3 C040 Tina Murphy 63 Well St. Glasgow G42 231-234-3478 3 CR74 Mike Ritchie 345-123-7234 House 750 4 B004 32 Manse Rd Bristol BS99 1NZ 4 C093 Tony Shaw 12 Park Pl. Glasgow G4 0QR 231-678-8648 4 CR62 Mary Tregear 01224-196720 Flat 600 5 B002 56 Clover Dr London NW10 6EU Photos - ITEC315LABO5StaffTable.png C315LABO5PropertyRentTable.png + Add to + hotos 4140 urose, Keith Ross Ba Filter in any column ON Table: PROPERTYRENT Table: STAFF ba Filter PROPERTYNO STREET CITY POSTCODE TYPE ROOMS RENT OWNERNO STAFFNO BRANCHNO STAFFNO FNAME LNAME POSITION SEX DOB SALARY BRANCHNO Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Section: Ch... Filter Filter Filter Filter 1 PA14 16 Holland Aberdeen AB1 5SU House 6 650 CO46 SA9 BO07 |1 SL21 John White Manager M 1-Oct-45 30000 BO05 2 PL94 6 Argyll St London NW2 Flat 4 400 C087 SL41 B005 2 SG37 Ann Birch Assistant F 10-Nov-60 12000 B003 he difference... 3 PG4 6 Lawrence St Glasgow G11 9QX Flat 350 C040 NULL B003 3 SG14 David Ford Supervisor M 23-Mar-58 18000 вооз 4 PG36 2 Manor Rd Glasgow G32 4QX Flat 3 375 C093 SG37 B003 4 SA9 Mary Howe Assistant 19-Feb-70 9000 B007 5 PG21 18 Dale Rd Glasgow G12 ar books House 5 600 C087 SG37 B003 5 SG5 Susan Brand Manager F 3-Jun-40 24000 B003 6 PG16 5 Novar Dr Glasgow G12 9AX Flat 450 C093 SG14 BO03 6 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 your !! of +
Transcribed Image Text:Photos - ITEC315LABO5PrivateOwnerTable.png Photos - ITEC315LABO5Viewing Table.png Photos - ITEC315LABO5Branch Table.png Photos - ITEC315LABO5ClientTable.png + + + 女 X。 Table: I VIEWING CLIENTNO PROPERTYNO VIEWDATE COMMENTS Table: BRANCH Table: PRIVATEOWNER Filter Filter Filter Filter Table: CLIENT 1 CR56 PA14 24-May-04 too small BRANCHNO STREET CITY POSTCODE OWNERNO FNAME LANME ADDRESS TELNO CLIENTNO FNAME LNAME TELNO PREFTYPE MAXRENT Filter Filter Filter Filter 2 CR62 PA14 14-May-04 no dining room Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter 3 CR56 26-May-04 NULL 1 BO05 22 Deer Rd London Sw1 4EH 1 C046 Joe Keogh 2 Fergus Dr. Aberdeen AB2 7Sx 012-234-5938 PG4 1 CR76 John Kay 123-345-7891 Flat 425 4 CR56 28-Apr-04 NULL 2 B007 16 Argyll St Aberdeen AB1 3SU PG36 2 C087 Carol Farrel 6 Array St. Glasgow G32 9DX 231-456-2222 2 CR56 Aline Stewart 213-344-7234 Flat 350 5 CR62 20-Apr-04 too remote 3 B003 163 Main St Glasgow G11 9QX PG4 3 C040 Tina Murphy 63 Well St. Glasgow G42 231-234-3478 3 CR74 Mike Ritchie 345-123-7234 House 750 4 B004 32 Manse Rd Bristol BS99 1NZ 4 C093 Tony Shaw 12 Park Pl. Glasgow G4 0QR 231-678-8648 4 CR62 Mary Tregear 01224-196720 Flat 600 5 B002 56 Clover Dr London NW10 6EU Photos - ITEC315LABO5StaffTable.png C315LABO5PropertyRentTable.png + Add to + hotos 4140 urose, Keith Ross Ba Filter in any column ON Table: PROPERTYRENT Table: STAFF ba Filter PROPERTYNO STREET CITY POSTCODE TYPE ROOMS RENT OWNERNO STAFFNO BRANCHNO STAFFNO FNAME LNAME POSITION SEX DOB SALARY BRANCHNO Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Section: Ch... Filter Filter Filter Filter 1 PA14 16 Holland Aberdeen AB1 5SU House 6 650 CO46 SA9 BO07 |1 SL21 John White Manager M 1-Oct-45 30000 BO05 2 PL94 6 Argyll St London NW2 Flat 4 400 C087 SL41 B005 2 SG37 Ann Birch Assistant F 10-Nov-60 12000 B003 he difference... 3 PG4 6 Lawrence St Glasgow G11 9QX Flat 350 C040 NULL B003 3 SG14 David Ford Supervisor M 23-Mar-58 18000 вооз 4 PG36 2 Manor Rd Glasgow G32 4QX Flat 3 375 C093 SG37 B003 4 SA9 Mary Howe Assistant 19-Feb-70 9000 B007 5 PG21 18 Dale Rd Glasgow G12 ar books House 5 600 C087 SG37 B003 5 SG5 Susan Brand Manager F 3-Jun-40 24000 B003 6 PG16 5 Novar Dr Glasgow G12 9AX Flat 450 C093 SG14 BO03 6 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 your !! of +
Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Microsoft Windows 10 Comprehensive 2019
Microsoft Windows 10 Comprehensive 2019
Computer Science
ISBN:
9780357392607
Author:
FREUND
Publisher:
Cengage
SEE MORE TEXTBOOKS