Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

in SQL, which month(s) and year(s) from question 8 have the highest payment total amount? Your query many not use a LIMIT clause. c Model

in SQL, which month(s) and year(s) from question 8 have the highest payment total amount? Your query many not use a LIMIT clause.

image text in transcribed

c Model employees orders paymentsx Limit to 5000rows 1SELECT FROM classicmodels.payments; 2 SELECT * FROM payments 3 W where paymentDateMax(amount); Result GridFiter Rows: | Edit:1 Export Import:wrap Cel Content: E customerNumber checkNumber paymentDate amount 103 HQ336336 JM555205 OM314933 B0864823 HQ55022 ND748579 GG31455 MA765515 2004-12-15 00:00:00 82261.22 2004-10-19 00:00:00 6066.78 2003-06-05 00:00:00 14571.44 2004-12-18 00:00:00 1676.14 2004-12-17 00:00:00 14191.12 2003-06-06 00:00:00 32641.98 2004-08-20 00:00:00 33347.88 2003-05-20 00:00:00 45864.03 Grid 103 103 112 112 112 114 114 114 114 119 119 119 121 121 121 Field Types NR27552 DB933704 LN373447 NG94694 DB889831 FD317790 KI831359 2003-05-3100:00:00 7565.08 2004-03-10 00:00:00 44894.74 2004-11-14 00:00:00 19501.82 2004-08-08 00:00:00 47924.19 2005-02-22 00:00:00 49523.67 2003-02-16 00:00:00 50218.95 2003-10-28 00:00:00 1491.38 2004-11-04 00:00:00 17876.32 Query payments 44 payments 45 x Revert

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

101 Database Exercises Text Workbook

Authors: McGraw-Hill

2nd Edition

0028007484, 978-0028007489

More Books

Students also viewed these Databases questions

Question

4. Support and enliven your speech with effective research

Answered: 1 week ago

Question

3. Choose an appropriate topic and develop it

Answered: 1 week ago