Icon

ITSCM774_​Team7_​Assign1

We use these simple queries to get alist of the stores (with locationinformation) and the staff (with theircontact information) that the bikecompany has. We use this query to gatherinformation on all the customersserviced by Mireya Copeland (Staff ID#2). We can use the information soMireya can send her customersmarketing material.We use this query for inventorypurposes to see all the available Trekbikes (Brand ID #9) at the Santa Cruzstore (Store ID #1). We use this query for HRpurposes. It gives us the amountof employees per state and sortsfrom least to most amount ofemployees.We use this query to keep trackof our customers in descendingorder of total amount of dollarsspent. We can use this for arewards or rebate program. Input SQLquery for store infoquery for all staffsales.customers tablesales.orders tablesales.staffs tablejoin with customer_idjoin with staff_idfilter by staff_idfilter for customer infofilter for bike infoproduction.stocks tablejoin with store_idproduction.products tablejoin with product_idfilter by store_id& brand_idsales.stores tablesales.staffs tablesales.stores tablejoin with store_idgroup by statesort by amountsort by total spendgroup bycustomer infosales.customers tablejoin with customer_idsales.orders tablejoin with order_idsales.orders_items tabletable readertable readertable readertable reader MySQL Connector DB Query Reader DB Query Reader DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Joiner DB Row Filter DB Column Filter DB Column Filter DB Table Selector DB Joiner DB Table Selector DB Joiner DB Row Filter DB Table Selector DB Table Selector DB Table Selector DB Joiner DB GroupBy DB Sorter DB Sorter DB GroupBy DB Table Selector DB Joiner DB Table Selector DB Joiner DB Table Selector DB Reader DB Reader DB Reader DB Reader We use these simple queries to get alist of the stores (with locationinformation) and the staff (with theircontact information) that the bikecompany has. We use this query to gatherinformation on all the customersserviced by Mireya Copeland (Staff ID#2). We can use the information soMireya can send her customersmarketing material.We use this query for inventorypurposes to see all the available Trekbikes (Brand ID #9) at the Santa Cruzstore (Store ID #1). We use this query for HRpurposes. It gives us the amountof employees per state and sortsfrom least to most amount ofemployees.We use this query to keep trackof our customers in descendingorder of total amount of dollarsspent. We can use this for arewards or rebate program. Input SQLquery for store infoquery for all staffsales.customers tablesales.orders tablesales.staffs tablejoin with customer_idjoin with staff_idfilter by staff_idfilter for customer infofilter for bike infoproduction.stocks tablejoin with store_idproduction.products tablejoin with product_idfilter by store_id& brand_idsales.stores tablesales.staffs tablesales.stores tablejoin with store_idgroup by statesort by amountsort by total spendgroup bycustomer infosales.customers tablejoin with customer_idsales.orders tablejoin with order_idsales.orders_items tabletable readertable readertable readertable readerMySQL Connector DB Query Reader DB Query Reader DB Table Selector DB Table Selector DB Table Selector DB Joiner DB Joiner DB Row Filter DB Column Filter DB Column Filter DB Table Selector DB Joiner DB Table Selector DB Joiner DB Row Filter DB Table Selector DB Table Selector DB Table Selector DB Joiner DB GroupBy DB Sorter DB Sorter DB GroupBy DB Table Selector DB Joiner DB Table Selector DB Joiner DB Table Selector DB Reader DB Reader DB Reader DB Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Current User
Created at: 2021-09-08
On NodePit since: 2021-09-11
Last update: 2024-04-27
Created with KNIME version: v4.4.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!