Using Microsoft SQL Server Management Studio, answer the following questions.

Utilizing Dillard's Data (WCOB_DILLARDS). *All I need is the query to type in!*

1. Provide a count of the number of stores in each state
2. Show the top 30 customer zip codes in the country according to sales (not net sales).
3. Select one state and, using 2015 data, show annual net sales (purchases minus refunds) for each store in that state. Show each store's number, city, state, and zip, and show results in descending order of annual net sales.

e Quick Launch (Ctrl+Q) a - I File SQL Query3.sql - essql1.walton.uark.edu.WCOB_DILLARDS (GACL ES508206 (62))* - Microsoft SQL Server Management Studio Edit View Query Project Tools Window Help New Query or A X NATHANIEL GOODALE WCOB_DILLARDS Execute 2 = ] 1 x SQL Query3.sql - es...CL\Esa508206 (62))* + X SELECT STATE FROM STORE GROUP BY STATE + Object Explorer Connect - * DLF001 GAF001 ORF001 PROJECT B_DILLARDS atabase Diagrams ables System Tables File Tables External Tables Graph Tables dbo.CUSTOMER dbo.DEPARTMENT dbo.SKU dbo.SKU_STORE dbo.STORE Columns STORE (PK, smallint, not null) DIVISION (char(2), not null) CITY (varchar(28), not null) ESTATE (char(2), not null) ZIP CODE (char(5), null) ZIP_SECSEG (char(4), null) 100 % Results BT Messages STATE 1 AL 2 AR 3 AZ 4 CA 5 CO 6 FL 7 GA 8 IA 9 ID IL 10 11 IN Keys 12 KS KY Constraints Triggers Indexes Statistics 13 14 LA 15 MO Query executed successfully. essql1.walton.uark.edu (14.... GACL\ESa508206 (62) WCOB_DILLARDS 00:00:00 30 rows D Ready Ln3 Col 15 Ch 15 INS e Quick Launch (Ctrl+Q) a - I File SQL Query3.sql - essql1.walton.uark.edu.WCOB_DILLARDS (GACL ES508206 (62))* - Microsoft SQL Server Management Studio Edit View Query Project Tools Window Help New Query or A X NATHANIEL GOODALE WCOB_DILLARDS Execute 2 = ] 1 x SQL Query3.sql - es...CL\Esa508206 (62))* + X SELECT STATE FROM STORE GROUP BY STATE + Object Explorer Connect - * DLF001 GAF001 ORF001 PROJECT B_DILLARDS atabase Diagrams ables System Tables File Tables External Tables Graph Tables dbo.CUSTOMER dbo.DEPARTMENT dbo.SKU dbo.SKU_STORE dbo.STORE Columns STORE (PK, smallint, not null) DIVISION (char(2), not null) CITY (varchar(28), not null) ESTATE (char(2), not null) ZIP CODE (char(5), null) ZIP_SECSEG (char(4), null) 100 % Results BT Messages STATE 1 AL 2 AR 3 AZ 4 CA 5 CO 6 FL 7 GA 8 IA 9 ID IL 10 11 IN Keys 12 KS KY Constraints Triggers Indexes Statistics 13 14 LA 15 MO Query executed successfully. essql1.walton.uark.edu (14.... GACL\ESa508206 (62) WCOB_DILLARDS 00:00:00 30 rows D Ready Ln3 Col 15 Ch 15 INS