Important
| CustomerNumber | Customer_FName | Customer_LName | Address | City | ZIP | Phone | mSysRowId |
|---|---|---|---|---|---|---|---|
| 1 | Patrick | Connelly | 631 E. Main St. | Richwood | 26261 | (304) 555-2190 | 1XadGInapk+ZllJVgJtemwtE+HB6cslFPtOrdbvLXgU=-~0tyyOwejJu1x51TxgUT8pw== |
| 2 | Isabel | Rosario | 96 Mountain Rd. | Princeton | 24740 | (304) 555-1890 | FFKezpiigtPCloLRZX2eWyxgk4SFhj1M32mDq8oRjAc=-~Y4wSRh4FRyaGIIwHU8j0/w== |
| 3 | Philip | Arutt | 1926 Street Rd. | Summersville | 26651 | (304) 555-6572 | 9c6piiSrHGvI9OtVEWUICpH9H7OBvQO8w4RdXtF2GhQ=-~d2H4KN44aXikD5gjnevWGg== |
| 4 | Lisa | Nemphos | 241 Harrison Ave. | Richwood | 26261 | (304) 555-0714 | V91XeUHtAIsqRC9N0AGrAk6JqEpqJLzv6LQ7VmhOaWo=-~Z7Z3ilEF8NqREJIrtrDL1g== |
| 5 | Hector | Melendez | 18 Jones Ave. | Richwood | 26261 | (304) 555-8206 | oNIvVdqPKpF2RXHmUbZJuJuWSoQ94KaCaYX6Rjfn7ck=-~18OumvFOexhqzh9i0WU4tA== |
| 6 | Gilesky | Shaw | 45 W. Ridge St. | Summersville | 26651 | (304) 555-9917 | l8RaVzlPFnSEkVOTZF1psea8ItNT5aQxzWg+nAQoljc=-~ZyscQjj84agUEEdP+zLlFA== |
| 7 | Jennifer | Katzeff | 161 Garth Rd. | Princeton | 24740 | (304) 555-4015 | Pjch85qK5HMdT+spLclUK7FMYnqslFgv5DJYJugBb/w=-~8c7AHo6j7z2bNc7OSD+25g== |
| ID | mSysRowId |
|---|---|
| 1 | kmWjKOKPpA6gVdSOEVdNFvTMyQoY2ZXX+mOHB6bNHwc=-~B2u/fjuG1hBcOSnlbM9DKg== |
| OrderNumber | CustomerNumber | OrderDate | ProductID | PhotographerID | mSysRowId |
|---|---|---|---|---|---|
| 1000 | 1 | 7/17/12 | RPS23005 | RZPzYZWIaJD4w/GnTVY/aUXAkWr/nQnL7Hqo8eS+qPA=-~lK6tLDELCDw7N8WTkQJgww== | |
| 2000 | 2 | 7/17/12 | RPS23005 | s8Ca2/bT0NVCphiHenp5FRlnXe6Lm9+PlN3W2Xkzgr4=-~7nhwttFUd794rvCtU6mmJw== | |
| 3000 | 3 | 7/17/12 | RPS23006 | h2o/4aMDminP6y1PvskjvnBUg4UcfoTDe9tVv8y/BmI=-~VkF5RD57J/XYDXdmZIeG6A== | |
| 4000 | 4 | 7/17/12 | RPS23007 | kjQn9yAZtZvZNrZ+BqRd5pRI3C+kb+IvZOymvIOjB5s=-~SpT2U1p6pCQ7kzPhoGDyFQ== | |
| 5000 | 5 | 7/17/12 | RPS23008 | J+/1f8iREstrMP58ae03SNvT5HfIQnjylL2LPfHkK4k=-~Qmep5IH8gfFQEpkmZrux7g== | |
| 6000 | 6 | 7/17/12 | RPS23006 | nekGO9gl6betsH2WSDOiBo3ezrhdmNMU62P4gRlUkYo=-~NiD6fIGTdjxTlOO0qoWHrw== | |
| 7000 | 7 | 7/17/12 | RPS23005 | wNNQoYXq9yrpCA2uiV9I8GlzXG2bSzTyNXrYqDT38kg=-~zkQB9Jt0WS9QfgWelQMqzw== |
| EmployeeID | First_Name | Last_Name | Schedule | mSysRowId |
|---|---|---|---|---|
| RPS23005 | Daniel | Pegg | VPExQwNHIlFQycfbwvYnLqhlarKbfmJwzz63CxpyeLA=-~D+0P4SJ+2GnM9ixgUO4DdA== | |
| RPS23006 | Renee | Harkins | iWiEnqoo9PxuBt/5GsiFBF7DQjpw76YzaY624jqf1i8=-~jtLnZWgPbhtwm1y9d4q6Yg== | |
| RPS23007 | Joshua | Scholl | iGped8EGNgxfccbAsSG5FyInaYgEHYj7f778AgWuuNk=-~2CfF8bNI7SfHBjaZ3bf63w== | |
| RPS23008 | Jessica | Rodriguez | Q2IW/R0tVOaHEwTj4y1SC4i2s+efa8rhxW9HhBpYtHg=-~A8x5X6k7IKEN57396JVyEw== |
| ProductID | Description | Price | mSysRowId |
|---|---|---|---|
| Enhancement1 | Black & White | ¤ 2.99 | Cqd0AF6FuJuLA0dKcQUOWUvWtMX82JVwONtxIE3BI2o=-~ECv7v1QInOPXd1dY1U9gqg== |
| Enhancement2 | Sepia | ¤ 2.99 | n1enJxID86gU/3qGZbuHwHpl3kO9uCpnREn0e0v/YGU=-~ZhobZX+im0LuMmm+woc/jw== |
| Enhancement3 | Vignette | ¤ 2.99 | 1AHBi1ZtSe19rhkJFss3r81lg5+DnrnE+aGlra2KLCM=-~ccV/pZbaqLc158ceH4E21w== |
| Package1 | Four Sheets; Two Enhancements | ¤ 25.00 | 9yOvE8FmcVweiBleyce2pyWrfCZuruupixHr9PRWh00=-~FPVSFd6aFM62wcFQByn7qA== |
| Package2 | Eight Sheets; One 10 X 13 Poster; Two Enhancements | ¤ 55.00 | i7lQS3N0a4JNjV3US3ijAABxK0Azw+TrpC1GS/n7snI=-~pEkcL8zXQ+ggHrdrDFVoxQ== |
| PortraitCD | Portrait CD | ¤ 59.99 | rRteOoKo3SrdPHEPcxAEPB7FV/fO7JvAFATk3SLSKV4=-~fPiM4lZgBJud9ikWxHhBtA== |
| PortraitSheet1 | One 8 X 10 | ¤ 5.99 | COre9ReOdb2a65/tATpa4Ituj4+pEuUcuUOGlwTC/7w=-~wrC6uzhgc3+bctzLCQoL3Q== |
| PortraitSheet2 | Two 5 X 7 | ¤ 5.99 | V34Q4rhVYpq5RfqK99NjsCQqTBpIrgrO4H8llvyA9Xs=-~gt2aNaMVUU3hY3yF6fqoJw== |
| PortraitSheet3 | Four 3 1/2 X 5 | ¤ 5.99 | +IRSAIhrzbdobKEL8Q0DZJZk/xLTozHwpyQZ6neVYA8=-~ch6EInLC+jUvnP+DlxcRZw== |
| PortraitSheet4 | Eight Wallets | ¤ 5.99 | acRboSNPRU9KqNgGD5JdS3JK7eZCXDRyRBy89X8kl5Y=-~D8jeF7Cc5MeWbxkWK5wMAg== |
| Poster1 | 10 X 13 | ¤ 20.99 | 7cDxd6joc/Cvgp4yKzvdSpcMG2rwKlFtFwxuZkhuejg=-~3jyBt+1IH/JaGBRaPl3LSw== |
| Poster2 | 16 X 20 | ¤ 25.99 | XF+I59eReM1HZZUK9PffqxGEnHM5zgGUYWXA4FnnthI=-~H6jIWDMpXUfIsCHx7ndulw== |
| Poster3 | 20 X 24 | ¤ 30.99 | Q0UiYBPF+lYdQZ0ohR6dudkjfYuXOLBJmerWYrEZRV8=-~5ljSzGwCJsCVrd5HhnQuSg== |
| SittingFee | Sitting Fee | ¤ 15.00 | yWdg317jCtRHVQsFy85abxLcITe1VDcXS4oL9fDlAsE=-~XLHpYQhiFq19l61fW9njcg== |
SELECT [Products].[ProductID]
FROM Products;
SELECT [Customer Information].[Customer_FName], [Customer Information].[Customer_LName], [Customer Information].[Address], [Customer Information].[City], [Customer Information].[ZIP], [Customer Information].[Phone], [Order Details].[OrderDate], [Order Details].[ProductID]
FROM [Customer Information] INNER JOIN [Order Details] ON [Customer Information].[CustomerNumber] =[Order Details].[CustomerNumber];
SELECT DISTINCTROW *
FROM Photographers;
SELECT DISTINCTROW *
FROM Products;
SELECT [Customer Information].Customer_FName, [Customer Information].Customer_LName, [Order Details].OrderDate, Sum(Products.Price) AS SumOfPrice
FROM Products INNER JOIN ([Customer Information] INNER JOIN [Order Details] ON [Customer Information].CustomerNumber=[Order Details].CustomerNumber) ON Products.ProductID=[Order Details].ProductID.Value
GROUP BY [Customer Information].Customer_FName, [Customer Information].Customer_LName, [Order Details].OrderDate;
SELECT DISTINCTROW [Customer Information].[Customer_FName], [Customer Information].[Customer_LName], [QESubquery_8E540BB96B3D46C7B4E5DDD89E582B49].[Order Details].[OrderDate], Sum([Products].[Price]) AS SumOfPrice
FROM Products INNER JOIN ([Customer Information] INNER JOIN [SELECT [Order Details].[CustomerNumber], [ProductID_9A868D4953084B219FBC4CBE85135049].[Value], [Order Details].[OrderDate]
FROM [Order Details] LEFT JOIN [f_E6640A865B3446B6B1C7CF874FAD0DF2_TempField*0] AS ProductID_9A868D4953084B219FBC4CBE85135049 ON [Order Details].[ProductID]=[ProductID_9A868D4953084B219FBC4CBE85135049].[_TempField*0]]. AS QESubquery_8E540BB96B3D46C7B4E5DDD89E582B49 ON [Customer Information].[CustomerNumber]=[QESubquery_8E540BB96B3D46C7B4E5DDD89E582B49].[Order Details].[CustomerNumber]) ON [Products].[ProductID]=[QESubquery_8E540BB96B3D46C7B4E5DDD89E582B49].[ProductID_9A868D4953084B219FBC4CBE85135049].[Value]
GROUP BY [Customer Information].[Customer_FName], [Customer Information].[Customer_LName], [QESubquery_8E540BB96B3D46C7B4E5DDD89E582B49].[Order Details].[OrderDate];
SELECT [Customer Information].Customer_FName, [Customer Information].Customer_LName, [Customer Information].Address, [Customer Information].City, [Customer Information].ZIP, [Customer Information].Phone, [Order Details].OrderDate, [Order Details].ProductID
FROM [Customer Information] INNER JOIN [Order Details] ON [Customer Information].CustomerNumber = [Order Details].CustomerNumber;