Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer the question in the first photo, which is related to the second photo as soon as possible!!!!!! Find all the checkout data where

image text in transcribed

image text in transcribed

please answer the question in the first photo, which is related to the second photo as soon as possible!!!!!!

Find all the checkout data where the checkout date is between 3/31/2017 and 4/30/2017 and Check due date is after 4/12/2017 command from SSMS ******/ ARAN ESELECT TOP (1000) [CHECK_NUM] [BOOK_NUM] [PAT_ID] [CHECK_OUT_DATE] [CHECK_DUE_DATE] [CHECK IN DATE] FROM [masterl:[dbol:[CHECKOUT 1 3 ) I 3 PATID 1165 1209 1160 1160 1202 1203 1174 100 % E Results Bi Messages CHECK_NUM BOOK_NUM 1 91001 5235 2 91002 5238 3 91003 5240 4 91004 5237 5 91005 5236 6 91006 5235 7 91007 5244 8 91008 5248 9 91009 5242 10 91010 5235 11 91011 5236 12 91012 5249 13 91013 5240 14 91014 5236 15 91015 16 91016 5236 17 91017 5240 Quenyecut 1181 1170 1161 CHECK_OUT_DATE 2017-03-31 2017-03-31 2017-03-31 2017-03-31 2017-03-31 2017-04-05 2017-04-05 2017-04-05 2017-04-05 2017-04-05 2017-04-05 2017-04-08 2017-04-10 2017-04-11 2017-04-11 2017-04-13 2017-04-14 CHECK_DUE_DATE 2017-04-14 2017-04-07 2017-04-14 2017-04-14 2017-04-07 2017-04-12 2017-04-12 2017-04-12 2017-04-19 2017-04-19 2017-04-12 2017-04-15 2017-04-24 2017-04-18 2017-04-18 2017-04-27 2017-04-21 CHECK_IN_DATE 2017-04-09 2017-04-05 2017-04-09 2017-04-03 2017-04-08 2017-04-13 2017-04-08 2017-04-06 2017-04-09 2017-04-05 2017-04-11 2017-04-12 2017-04-19 2017-04-19 2017-04-13 2017-04-14 2017-04-22 1181 1181 1160 5237 1204 1204 1183 1184

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

Database Reliability Engineering Designing And Operating Resilient Database Systems

Authors: Laine Campbell, Charity Majors

1st Edition

978-1491925942

More Books

Students also viewed these Databases questions