Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a SQL statment in access that produce a list of names of service companies that have checked the lifts at least once for all

Write a SQL statment in access that produce a list of names of service companies that have checked the lifts at least once for all lifts in a housing company image text in transcribed

image text in transcribed

Housing company Housing company - floor x B Property orgnr x lift x lift checking list > mm Property x L x H checking ist X pid . Built year postadress streetadress 1999 kista abcvagen 1 2000 kista defvgen 1 2017 sollentuna hallonstipen 3 2017 stockholm hallonstige 3 2003 stockholm hallonstigen 2 2004 stockholm wallingvingen 1 2003 stockholm armanvagen 4 1987 stockholm walingatan 2 1957 sollentuna prisvagen 1 2019 kista hallonstigen 3 2018 nacka prisvegen 1 2018 nacka smultronstige 1976 sodertalje bakgatan 2 2014 wisters avloppsgatan 5 2013 lule nordgatan 4 19 2017 Kiruna Kungsvgen 2 1961 malm prinssien 1 1919 malmo pristin 40 1984 teborg hallgatan 1 22 1990 goteborg stigen 3 1990 stockholm Sveavgen 4 1990 stockholm Sveavgen 5 1990 stockholm Sveavgen 1 (Nyl 1 2 3 Housing company name - + solglantan manskenet #nyponet + park myrstacken + smaragden NWNWNWANAN-NWNW 5 6 e X X X Housing company liftsid X Property property Lift name SA Housing company Property X X 2 lift checking list lift date of the next checkout. lift service compan. 9/10/2016 Anderssons Hiss 8/10/2015 Nilcons Service 10/23/2015 Nilzons Service 1/17/2017 Nilzons Service 7/12/2016 HSIS 4/1/2015 Anderssons Hiss 10/11/2015 Nilzons Service 12/1/2013 Nilzons Service 8/19/2018 HSIS 3/2/2019 HSIS 3/22/2015 Nilzons Service 9/16/2020 Anderssons Hiss SB 500 checking list X next check - maxwieght - max quentity 9/10/2021 400 8/10/2020 350 10/23/2020 1/17/2022 300 7/12/2021 800 4/1/2020 8/19/2023 250 3/2/2024 3/22/2020 800 9/16/2025 400 13 A 13 B 130 400 151 500 152 16 A (Ny) lift' date of the next checkout lift service company 1 9/10/2016 Anderssons Hiss - 2 8/10/2015 Nilzons Service 10/23/2015 Nilzons Service 1/17/2017 Nilzons Service 7/12/2016 HSIS 4/1/2015 Anderssons Hiss 10/11/2015 Nilzons Service 12/1/2013 Nilzons Service 8/19/2018 HSIS 3/2/2019 HSIS 3/22/2015 Nilzons Service 9/16/2020 Anderssons Hiss

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

What is group replacement? Explain with an example. (2-3 lines)

Answered: 1 week ago

Question

Discuss communication challenges in a global environment.

Answered: 1 week ago