Exercise 1 1. Use the following table to answer the questions below. Homeroom#First NameLast NameT-Shirt SizePayment Method105DerekMacDonaldLargeCash105NathanAlbeeMediumCheck105SidneyKellyMediumCheck105ChristianaChenMediumCheck Bounced105MelissaWhiteSmallDebit Card105EstherYaronSmallPending110KrisAckermanLargeCredit Card110MattBensonMediumMoney Order110GabrielDel ToroMediumCash110LilianArnoldX-LargeCash135AnisaNaserSmallCheck Bounced135DaviBellX-LargeCredit Card220-AAsherHepburnLargePending220-ABrigidEllisonSmallCash220-AChristopherPeyton-GomezSmallCheck 220-BAveryKellyLargeMoney Order220-BSamanthaBellMediumCheck220-BMichaelLazarSmallCash220-BMalikReynoldsSmallCash220-BWendyShawSmallCash 1. Sort by Last Name (desc), then T-Shirt Size (asc) and then Payment Method (desc). 2. Freeze row panes from 1-7 so that when you scroll down data remains on screen.

Both answers are explained below

Answered: Sort by Last Name (desc), then T-Shirt…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Exercise 1

1. Use the following table to answer the questions below.

Homeroom#	First Name	Last Name	T-Shirt Size	Payment Method
105	Derek	MacDonald	Large	Cash
105	Nathan	Albee	Medium	Check
105	Sidney	Kelly	Medium	Check
105	Christiana	Chen	Medium	Check Bounced
105	Melissa	White	Small	Debit Card
105	Esther	Yaron	Small	Pending
110	Kris	Ackerman	Large	Credit Card
110	Matt	Benson	Medium	Money Order
110	Gabriel	Del Toro	Medium	Cash
110	Lilian	Arnold	X-Large	Cash
135	Anisa	Naser	Small	Check Bounced
135	Davi	Bell	X-Large	Credit Card
220-A	Asher	Hepburn	Large	Pending
220-A	Brigid	Ellison	Small	Cash
220-A	Christopher	Peyton-Gomez	Small	Check
220-B	Avery	Kelly	Large	Money Order
220-B	Samantha	Bell	Medium	Check
220-B	Michael	Lazar	Small	Cash
220-B	Malik	Reynolds	Small	Cash
220-B	Wendy	Shaw	Small	Cash

1. Sort by Last Name (desc), then T-Shirt Size (asc) and then Payment Method (desc).
2. Freeze row panes from 1-7 so that when you scroll down data remains on screen.

Expert Solution

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions