SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
/* A database contains customer billing records stored in two tables, CUSTOMERS and INVOICES. Determine the maximum VALUE in the INVOICES table, then print the NAMEs and IDs of all customers who have an invoice VALUE of that amount. Order the results by customer's name. */ CREATE TABLE customers ( name VARCHAR(255), id VARCHAR(255) ); CREATE TABLE invoices ( customer_id varchar(255), value INT ); INSERT INTO customers VALUES('Mindy Rosario', '9aa8af3678334f0e8f0ebcb22ca46107'); INSERT INTO customers VALUES('Joel Rowland', 'c0b86a84391746c5a1cc39a42d74304d'); INSERT INTO customers VALUES('Jean Fowler', '146434f56e564f0aa9d36333b3f20c70'); INSERT INTO customers VALUES('Lee Sanchez PhD', '3cdd7e9a7dd14900a16f0d0f7cd35df4'); INSERT INTO customers VALUES('Christopher Banks', 'd8a75a593e6d4ed882328e6492bc655e'); INSERT INTO customers VALUES('David Dillon', '20eb79cb23ec4e8e90fe3601471b365a'); INSERT INTO customers VALUES('Michael Matthews', '4d72bdc1a37f41d19ee2b385b508fc7a'); INSERT INTO customers VALUES('Daniel Lowery', '5f11566c8879448ebfee0ab7287ad52d'); INSERT INTO customers VALUES('David Wyatt', 'b463718b6883466dbfe1fa928bb28532'); INSERT INTO customers VALUES('Colin Allison', '62e0a763df6f4cceb3b698e13caeaab6'); INSERT INTO customers VALUES('Marc Bryant', '10e7e3d3173d49ba95221c07816242ad'); INSERT INTO customers VALUES('Mary Williams', '17f6bc0447064a899e18635d737ea840'); INSERT INTO customers VALUES('Christopher Horton', '3719d5c84b6b4319ab092e42cd26e981'); INSERT INTO customers VALUES('Ray Anderson', '6e7effeac2924628a37829f41b6d22b1'); INSERT INTO customers VALUES('Jennifer Costa', '8ca5ec1934d84339b98612f84de779dd'); INSERT INTO customers VALUES('Eric Brown', '70a2e430b1864b43a6b0f0bf2ddc13a4'); INSERT INTO customers VALUES('Jennifer Mendoza', '6b2c7087d6aa456e86313473477aa472'); INSERT INTO customers VALUES('Lindsey Steele', 'd5b741ad31cd4ada982c7a0bde7ddbbb'); INSERT INTO customers VALUES('Patrick Brown', '573eb0af1bb040fa913cc2ca66eb294b'); INSERT INTO customers VALUES('Stephanie Nielsen', '70b6cbaa2f3a460c8d91ff05a21eeb5f'); INSERT INTO customers VALUES('Tina Maxwell', '426ca8feb23548b38e6339624486ed4c'); INSERT INTO customers VALUES('Paul Perez', 'b913a4e6b3614bf5a4a63eb9db2b9500'); INSERT INTO customers VALUES('Cynthia Wilson', 'ce428767bd684e588726a471396e271b'); INSERT INTO customers VALUES('Diana Black', '2937ed7f3bd7447589fe313f3d0d5362'); INSERT INTO customers VALUES('Jason Harris', '2df00653edb5412ab72fc269464175aa'); INSERT INTO customers VALUES('Brenda Navarro', 'a659661a45b8464f8cf6e9317e5c5179'); INSERT INTO customers VALUES('James Reed', 'd0f2ee07bcdd4cbba53d68412a890a23'); INSERT INTO customers VALUES('Paul Vazquez', '052e05e40b02454691169ea06cc9ea50'); INSERT INTO customers VALUES('Kristin Fields', 'f9a5bfa42f5d48479972d0dd4ce2be3b'); INSERT INTO customers VALUES('Jessica Hansen', '00b0c9796ba4489aa8a86f929664ea42'); INSERT INTO customers VALUES('Eric Schmitt', 'a53931bfd1d849d5b4c04cce414b213e'); INSERT INTO customers VALUES('Barbara Vega', 'aefcb38a0322461faa4b0598f1749854'); INSERT INTO customers VALUES('William Jackson', 'e9fe6e616b1840059e74f9491e45c3c2'); INSERT INTO customers VALUES('Alexander Peters', 'eee7712ff22c418db5bbad4ba3fd4f2b'); INSERT INTO customers VALUES('Sabrina Reilly', '01110b040d45449eab9df87107292784'); INSERT INTO customers VALUES('Sherry Baird', '5245403dc51044f491a5c20dbb432f07'); INSERT INTO customers VALUES('Misty Hamilton', '76bd90b26dd040f6aa5461169e7d42ba'); INSERT INTO customers VALUES('Crystal Peterson', '0a4de767d30747f3aa8470f307ad351f'); INSERT INTO customers VALUES('Christian Lee', 'a5bdd7c3a338496a8602e4b1408a3abb'); INSERT INTO customers VALUES('Edward Peterson', 'b4ed82b9d14e43cf87ae0ae3f36c192c'); INSERT INTO customers VALUES('Emily Garcia', '3a0597076c604d1e977eb67720edd2ca'); INSERT INTO customers VALUES('Philip Medina', '2bb50cf700524af9acd3ae4635470a07'); INSERT INTO customers VALUES('Cheryl Jones', 'ba2fcf6e22a240feac241dbd55913f9e'); INSERT INTO customers VALUES('Hannah Bowen', '6abe96f876a34aa6ba85bd7375941d38'); INSERT INTO customers VALUES('Jeremy Chapman', 'fe7df2e2c8e64c9faa9aea2e782b644e'); INSERT INTO customers VALUES('Paula Johnson', '66e6ae9f82d84301b4b5ea5b7b887acd'); INSERT INTO customers VALUES('Christopher May', '4505a7db8fcd44b6b2e3c0fb788c0f22'); INSERT INTO customers VALUES('Richard Harrison', '07df9c6c14aa4a6f813d432e0a4d5c7b'); INSERT INTO customers VALUES('Sandra Garcia', '8c526a9b281a4f9ebbcb46a733643229'); INSERT INTO customers VALUES('Laura Moss', 'ac17649ba91d4cceb275fba10d29f303'); INSERT INTO customers VALUES('Douglas Lindsey', '13d37a3369304d37aee637154701a074'); INSERT INTO customers VALUES('Robert Nicholson', 'b983b1fee7064f1f88239389c19e7cbf'); INSERT INTO customers VALUES('Jessica Lee', 'c43a93642ce2474c91a95e8cefa53b3e'); INSERT INTO customers VALUES('Jason Fritz', '058516eb947d4eb18dca1846fd8e7617'); INSERT INTO customers VALUES('Elizabeth Holt', 'cbb79c296fd94489b6f69113d2a7de0e'); INSERT INTO customers VALUES('Angela Potts', 'f0d08254d94445518d5710d809beefdf'); INSERT INTO customers VALUES('Heather Terry', '1036b84c305d49c9aa7dccafa8234247'); INSERT INTO customers VALUES('Christopher Camacho', 'facab49787944af5ae2f7dfc9b38c38e'); INSERT INTO customers VALUES('Robert Fisher', '910ca20d93714e1cb219943ef53d8a9b'); INSERT INTO customers VALUES('Thomas Roman', 'd07a57d303f249c78aeacb17aadf9d83'); INSERT INTO customers VALUES('Tamara Erickson', '2a7ee12dff284c8f9694993c195c4040'); INSERT INTO customers VALUES('Paul Russell', 'd4a276e1801048599e465989b81f8cdc'); INSERT INTO customers VALUES('Jeffrey Ellis', 'c905cf3989ca47e38a1b58d2710917bd'); INSERT INTO customers VALUES('Alexa Smith', 'b14215c0c59640edb2c65c872860f63a'); INSERT INTO customers VALUES('Michael Beltran', '406e5ba2f329423f87ed157a4cd45df5'); INSERT INTO customers VALUES('Trevor Hall', '4eddd1757c8d489591a2079474062678'); INSERT INTO customers VALUES('Michael Hartman', 'fe83f45ede2441cd8bbd0e5316f1436b'); INSERT INTO customers VALUES('Jessica Baldwin', '97467fd1e8dd47e9936284ea8241ec5d'); INSERT INTO customers VALUES('Claire Hanna', '181e5b2e7ebe4e2fab95a6db5dd6c92f'); INSERT INTO customers VALUES('Melanie Stevens', '97a467d4c7d044aaac16409be7a7b7e7'); INSERT INTO customers VALUES('Patrick Vasquez', '9062b445cb574f308e8f24fb7146912c'); INSERT INTO customers VALUES('Julia Farrell', '908c5fe81bbd4ce19e89682ae843b33a'); INSERT INTO customers VALUES('Charles Meyer', '30b29ceed50b4d9e941ff1f634d1a3e9'); INSERT INTO customers VALUES('Stanley Livingston', 'e76022aba0744085b81b9182894729e2'); INSERT INTO customers VALUES('Michael Smith', '489d6a56b20b4464870c501de9c8fd75'); INSERT INTO customers VALUES('Larry Wiley', '4246931bde154042800e9dd02d757be9'); INSERT INTO customers VALUES('Ryan Taylor', 'a747afecf42c4668af30e348abf964b8'); INSERT INTO customers VALUES('Ashley Holland', '04b581dc77d74b4dadf96c6914962ade'); INSERT INTO customers VALUES('Richard Howard', '344ff5d475894567bbb9f430ded2bbfd'); INSERT INTO customers VALUES('Brandy Santos', '9033a31006c34d8e9b2a30b2b01927fb'); INSERT INTO customers VALUES('Taylor Hall PhD', 'f94e9d6ec6fb4ab48ea8de396ba50a12'); INSERT INTO customers VALUES('Gilbert Walters', '5a18b9e3498c40209f492af92080b0d5'); INSERT INTO customers VALUES('Christopher Guzman MD', 'c6134b1e4ed8438abdd0e7294ba602da'); INSERT INTO customers VALUES('Barry Lopez', 'e6b467aecc2b4a2fa49313ea2240cb57'); INSERT INTO customers VALUES('Erin Baldwin', 'c15baff9d8a247f28deef0ba17d924b8'); INSERT INTO customers VALUES('Kendra Mullins', '00f1f8f22c554f259e8b4d2545da7b7f'); INSERT INTO customers VALUES('Adrian Hall', '6c62df3c8e2c42dab4329e9c38cdb621'); INSERT INTO customers VALUES('Rachel Kirby', '0e03d15312be41b3b3ff17313ff509b0'); INSERT INTO customers VALUES('Denise Parker', '62c46246c3ab455c84d70dd51c8c4389'); INSERT INTO customers VALUES('Tyler Rodriguez', '6aae7371bcf64fa195cf3dd4080f5ff7'); INSERT INTO customers VALUES('Victoria Hawkins', 'b8793d6379a246d9908e501785201513'); INSERT INTO customers VALUES('Teresa Baker', 'bf4a9b8b580b4e7d95c2af3651f3ec4c'); INSERT INTO customers VALUES('Katie Lara', '531fe40834064a01ba2c15b3f9c8b0f0'); INSERT INTO customers VALUES('Danielle Harris', '2950e9bbc42648f78c38280cfe71d6f0'); INSERT INTO customers VALUES('Sarah Brown', '030d81ec6dce4d2ab288838c0429eae3'); INSERT INTO customers VALUES('David Garcia', '24c86c43a08b4dfc86d71c537cd3150d'); INSERT INTO customers VALUES('Jason Goodman', '7d218c370ab24c76afbe1412f42d09d8'); INSERT INTO customers VALUES('Alexander Johnson', 'a33af9e9d21c43e194bd997ed2f1529b'); INSERT INTO customers VALUES('Carla Snyder', '9fe000dba64743249bdcaf14836f5aec'); INSERT INTO customers VALUES('Katie Nguyen', '9373289674344cf5aa949a92b40ff59c'); INSERT INTO invoices VALUES('9aa8af3678334f0e8f0ebcb22ca46107', 775); INSERT INTO invoices VALUES('c0b86a84391746c5a1cc39a42d74304d', 626); INSERT INTO invoices VALUES('146434f56e564f0aa9d36333b3f20c70', 1280); INSERT INTO invoices VALUES('3cdd7e9a7dd14900a16f0d0f7cd35df4', 1896); INSERT INTO invoices VALUES('d8a75a593e6d4ed882328e6492bc655e', 231); INSERT INTO invoices VALUES('20eb79cb23ec4e8e90fe3601471b365a', 1136); INSERT INTO invoices VALUES('4d72bdc1a37f41d19ee2b385b508fc7a', 626); INSERT INTO invoices VALUES('5f11566c8879448ebfee0ab7287ad52d', 1061); INSERT INTO invoices VALUES('b463718b6883466dbfe1fa928bb28532', 669); INSERT INTO invoices VALUES('62e0a763df6f4cceb3b698e13caeaab6', 1267); INSERT INTO invoices VALUES('10e7e3d3173d49ba95221c07816242ad', 1524); INSERT INTO invoices VALUES('17f6bc0447064a899e18635d737ea840', 1787); INSERT INTO invoices VALUES('3719d5c84b6b4319ab092e42cd26e981', 1082); INSERT INTO invoices VALUES('6e7effeac2924628a37829f41b6d22b1', 1307); INSERT INTO invoices VALUES('8ca5ec1934d84339b98612f84de779dd', 1159); INSERT INTO invoices VALUES('70a2e430b1864b43a6b0f0bf2ddc13a4', 1734); INSERT INTO invoices VALUES('6b2c7087d6aa456e86313473477aa472', 1753); INSERT INTO invoices VALUES('d5b741ad31cd4ada982c7a0bde7ddbbb', 542); INSERT INTO invoices VALUES('573eb0af1bb040fa913cc2ca66eb294b', 1696); INSERT INTO invoices VALUES('70b6cbaa2f3a460c8d91ff05a21eeb5f', 509); INSERT INTO invoices VALUES('426ca8feb23548b38e6339624486ed4c', 321); INSERT INTO invoices VALUES('b913a4e6b3614bf5a4a63eb9db2b9500', 1133); INSERT INTO invoices VALUES('ce428767bd684e588726a471396e271b', 789); INSERT INTO invoices VALUES('2937ed7f3bd7447589fe313f3d0d5362', 216); INSERT INTO invoices VALUES('2df00653edb5412ab72fc269464175aa', 1433); INSERT INTO invoices VALUES('a659661a45b8464f8cf6e9317e5c5179', 1079); INSERT INTO invoices VALUES('d0f2ee07bcdd4cbba53d68412a890a23', 1449); INSERT INTO invoices VALUES('052e05e40b02454691169ea06cc9ea50', 1297); INSERT INTO invoices VALUES('f9a5bfa42f5d48479972d0dd4ce2be3b', 155); INSERT INTO invoices VALUES('00b0c9796ba4489aa8a86f929664ea42', 664); INSERT INTO invoices VALUES('a53931bfd1d849d5b4c04cce414b213e', 1366); INSERT INTO invoices VALUES('aefcb38a0322461faa4b0598f1749854', 1779); INSERT INTO invoices VALUES('e9fe6e616b1840059e74f9491e45c3c2', 740); INSERT INTO invoices VALUES('eee7712ff22c418db5bbad4ba3fd4f2b', 744); INSERT INTO invoices VALUES('01110b040d45449eab9df87107292784', 419); INSERT INTO invoices VALUES('5245403dc51044f491a5c20dbb432f07', 1653); INSERT INTO invoices VALUES('76bd90b26dd040f6aa5461169e7d42ba', 673); INSERT INTO invoices VALUES('0a4de767d30747f3aa8470f307ad351f', 448); INSERT INTO invoices VALUES('a5bdd7c3a338496a8602e4b1408a3abb', 1891); INSERT INTO invoices VALUES('b4ed82b9d14e43cf87ae0ae3f36c192c', 1946); INSERT INTO invoices VALUES('3a0597076c604d1e977eb67720edd2ca', 457); INSERT INTO invoices VALUES('2bb50cf700524af9acd3ae4635470a07', 440); INSERT INTO invoices VALUES('ba2fcf6e22a240feac241dbd55913f9e', 1919); INSERT INTO invoices VALUES('6abe96f876a34aa6ba85bd7375941d38', 1814); INSERT INTO invoices VALUES('fe7df2e2c8e64c9faa9aea2e782b644e', 208); INSERT INTO invoices VALUES('66e6ae9f82d84301b4b5ea5b7b887acd', 1727); INSERT INTO invoices VALUES('4505a7db8fcd44b6b2e3c0fb788c0f22', 1621); INSERT INTO invoices VALUES('07df9c6c14aa4a6f813d432e0a4d5c7b', 1053); INSERT INTO invoices VALUES('8c526a9b281a4f9ebbcb46a733643229', 329); INSERT INTO invoices VALUES('ac17649ba91d4cceb275fba10d29f303', 140); INSERT INTO invoices VALUES('13d37a3369304d37aee637154701a074', 593); INSERT INTO invoices VALUES('b983b1fee7064f1f88239389c19e7cbf', 397); INSERT INTO invoices VALUES('c43a93642ce2474c91a95e8cefa53b3e', 457); INSERT INTO invoices VALUES('058516eb947d4eb18dca1846fd8e7617', 661); INSERT INTO invoices VALUES('cbb79c296fd94489b6f69113d2a7de0e', 1265); INSERT INTO invoices VALUES('f0d08254d94445518d5710d809beefdf', 1986); INSERT INTO invoices VALUES('1036b84c305d49c9aa7dccafa8234247', 364); INSERT INTO invoices VALUES('facab49787944af5ae2f7dfc9b38c38e', 1571); INSERT INTO invoices VALUES('910ca20d93714e1cb219943ef53d8a9b', 328); INSERT INTO invoices VALUES('d07a57d303f249c78aeacb17aadf9d83', 452); INSERT INTO invoices VALUES('2a7ee12dff284c8f9694993c195c4040', 197); INSERT INTO invoices VALUES('d4a276e1801048599e465989b81f8cdc', 1986); INSERT INTO invoices VALUES('c905cf3989ca47e38a1b58d2710917bd', 1607); INSERT INTO invoices VALUES('b14215c0c59640edb2c65c872860f63a', 1700); INSERT INTO invoices VALUES('406e5ba2f329423f87ed157a4cd45df5', 135); INSERT INTO invoices VALUES('4eddd1757c8d489591a2079474062678', 454); INSERT INTO invoices VALUES('fe83f45ede2441cd8bbd0e5316f1436b', 448); INSERT INTO invoices VALUES('97467fd1e8dd47e9936284ea8241ec5d', 1220); INSERT INTO invoices VALUES('181e5b2e7ebe4e2fab95a6db5dd6c92f', 375); INSERT INTO invoices VALUES('97a467d4c7d044aaac16409be7a7b7e7', 1848); INSERT INTO invoices VALUES('9062b445cb574f308e8f24fb7146912c', 495); INSERT INTO invoices VALUES('908c5fe81bbd4ce19e89682ae843b33a', 1961); INSERT INTO invoices VALUES('30b29ceed50b4d9e941ff1f634d1a3e9', 364); INSERT INTO invoices VALUES('e76022aba0744085b81b9182894729e2', 1986); INSERT INTO invoices VALUES('489d6a56b20b4464870c501de9c8fd75', 1480); INSERT INTO invoices VALUES('4246931bde154042800e9dd02d757be9', 1048); INSERT INTO invoices VALUES('a747afecf42c4668af30e348abf964b8', 1986); INSERT INTO invoices VALUES('04b581dc77d74b4dadf96c6914962ade', 1275); INSERT INTO invoices VALUES('344ff5d475894567bbb9f430ded2bbfd', 704); INSERT INTO invoices VALUES('9033a31006c34d8e9b2a30b2b01927fb', 1223); INSERT INTO invoices VALUES('f94e9d6ec6fb4ab48ea8de396ba50a12', 678); INSERT INTO invoices VALUES('5a18b9e3498c40209f492af92080b0d5', 1913); INSERT INTO invoices VALUES('c6134b1e4ed8438abdd0e7294ba602da', 865); INSERT INTO invoices VALUES('e6b467aecc2b4a2fa49313ea2240cb57', 1634); INSERT INTO invoices VALUES('c15baff9d8a247f28deef0ba17d924b8', 171); INSERT INTO invoices VALUES('00f1f8f22c554f259e8b4d2545da7b7f', 816); INSERT INTO invoices VALUES('6c62df3c8e2c42dab4329e9c38cdb621', 1373); INSERT INTO invoices VALUES('0e03d15312be41b3b3ff17313ff509b0', 1886); INSERT INTO invoices VALUES('62c46246c3ab455c84d70dd51c8c4389', 1084); INSERT INTO invoices VALUES('6aae7371bcf64fa195cf3dd4080f5ff7', 744); INSERT INTO invoices VALUES('b8793d6379a246d9908e501785201513', 289); INSERT INTO invoices VALUES('bf4a9b8b580b4e7d95c2af3651f3ec4c', 1539); INSERT INTO invoices VALUES('531fe40834064a01ba2c15b3f9c8b0f0', 1006); INSERT INTO invoices VALUES('2950e9bbc42648f78c38280cfe71d6f0', 1884); INSERT INTO invoices VALUES('030d81ec6dce4d2ab288838c0429eae3', 1429); INSERT INTO invoices VALUES('24c86c43a08b4dfc86d71c537cd3150d', 1986); INSERT INTO invoices VALUES('7d218c370ab24c76afbe1412f42d09d8', 729); INSERT INTO invoices VALUES('a33af9e9d21c43e194bd997ed2f1529b', 1659); INSERT INTO invoices VALUES('9fe000dba64743249bdcaf14836f5aec', 333); INSERT INTO invoices VALUES('9373289674344cf5aa949a92b40ff59c', 1373); /* A database contains customer billing records stored in two tables, CUSTOMERS and INVOICES. Determine the maximum VALUE in the INVOICES table, then print the NAMEs and IDs of all customers who have an invoice VALUE of that amount. Order the results by customer's name. CREATE TABLE customers ( name VARCHAR(255), id VARCHAR(255) ); CREATE TABLE invoices ( customer_id varchar(255), value INT ); */ select i.customer_id, max(i.value) from invoices i group by i.customer_id having i.value = max(i.value)
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear