Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This query should return 13 rows. Please point me to the mistake in my code. MySQL Workbench Local instance 3306 x Query 1 AL-HW07 TALimit

This query should return 13 rows. Please point me to the mistake in my code.

image text in transcribed

MySQL Workbench Local instance 3306 x Query 1 AL-HW07 TALimit to 1000 rows Q Filter objects ON ?.owner-num ms.owner.num 28 WHERE o.city "Glander Bay" AND ms.boat type "Sprite 4000" 29 service-request i -i ?Columns ? Find the service ID and slip ID for each service request whose estimated hours is greater than the number of stimated hours of at least one service request on which the category number is 3. (13 rows)7 ? 32 service ID 34 SELECT service_ID, slip ID 35 36 37 38 ? slip-ID FROM service request sr WHERE est hours> category_num SELECT est_hours ROM service_request WHERE category_num 3); description status 40 41 42 SELECT est-hours, service-ID, slip-ID, category-num FROM service request; ? est-hours spent_hours ? next-service-date | 100% v 34:38 Indexes Q Search Edit: ???Export/Import:?? Result Grid Fiter Rows: est hours service ID slip ID category num 4.00 2.00 1.00 2.00 4.00 3.00 2.00 4.00 8.00 7.00 1 n0 Foreign Keys ?Triggers Views Stored Procedures Functions E ap ex Object Info Session Table: service_request st 13

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_2

Step: 3

blur-text-image_3

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

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

9th Edition

0135188148, 978-0135188149, 9781642087611

More Books

Students also viewed these Databases questions