Question: I need help with an SQL query with the following questions How many territories are there? How many territories are there in each region? The
I need help with an SQL query with the following questions
How many territories are there? How many territories are there in each region?
The table is attached:

EMENT rver Status ient Connections sers and Privileges atus and System Variables ata Expont ata Import/Restore CE artup Shutdown rver Logs ptions File MANCE ashboard rformance Reports rformance Schema Setup Limit to 1000 rows" 1 select* 2 FROM territories Result Grid Filter Rows: Edit: Wrap Cell ContEEE TerritoryID TerritoryDescription 01581 01730 01833 02116 02139 02184 02903 03049 03801 06897 07960 08837 10019 10038 11747 14450 19428 19713 20852 27403 27511 RegionID Westbord Bedford Georaetow Boston Braintree Providence Hollis Portsmouth Wilton Morristown Types Columns Ep Indexes New York New York Fairport Neward Greensboro Foreign Keys > ] Triggers employeeterritories orderdetails orders products region shippers suppliers territories territories 30 Apply Revert Action Output ion Message 3 63 17:06:24 SELECT DISTINCT TeritorylD, TeritoryDescription FROM Temitori.. Error Code: 1064. You have an error in your SQL sy 64 17:06:29 SELECT DISTINCT TemtorylD, TemitoryDescription FROM Temtori... 53 row s) retumed 3 65 17:06:52 SELECT DISTINCT COUNT (TeritorylD). TeritoryDescription FRO.. Eror Code: 1630. FUNCTION northwind COUNT do varchar (20) PK 0 ryDescription varchar(50) nID int (11)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
