![]() ![]() `orderDET` SELECT * FROM categories SELECT * FROM customers SELECT * FROM employees SELECT * FROM orderDET limit 3000 SELECT * FROM orders limit 3000 SELECT * FROM products Employee Performance With this basic information in hand, I dive into some analyses.ĪLTER TABLE `northwind`. Lastly, there are 9 employees, 5 of whom operate in the United States and 4 in the United Kingdom. In some of those orders, customers purchased multiple products there are 2155 product orders. There are 91 customers who have collectively placed 830 complete orders. There are 77 distinct products and 9 product categories. The preliminary analyses give a good overview of the data. ![]() After changing the name of the “order details” relation to “orderDET” for easier referencing, I get to work. products (details about specific products)īefore jumping into any more complicated queries, it useful to get an initial picture of what each relation contains.order details (additional details about orders).employees (information about Northwind’s employees).customers (information about Northwind’s customers).The database contains 13 tables (relations), six of which I use for the analyses discussed later: The Northwind database contains sales data about a fictitious company. All of the analyses herein were done in MySQL using the MySQL Workbench GUI. In this post, I walk through some queries and analyses I performed on the oft-used Northwindĭata. After taking six online courses and working through numerous excercises, I wanted to get my hands dirty with some data in a more applied way. ![]() I’ve been focusing recently on trying to take my SQL skills to the next level – defining more complicated subqueries, working with triggers and views, Online Analytical Processing tools, and the like. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |