DB Browser for SQLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Altach Database X Close Database Database Structure Execute So Browse Data Create Index Edit Pragmas Print Create Table Type Schema Name Tables (9) > 5 customer > is dept > is emp > is_inventory > is_item > S_ord > os product > ms_region > s_warehouse Indices (0) Views (0) Triggers (0) CREATE TABLE "s customer" ( "id" INTEGER, "name" TEXT, "phone" TEXT, "address" TEXT, "city" TEXT, "state" TEXT, "country" TEXT, "zip code" TEXT, "credit ra CREATE TABLE "s_dept" ( "id" INTEGER, "name" TEXT, "region_id" INTEGER, FOREIGN KEY("region_id") REFERENCES "s_region"("id"), PRIMARY KEY("id")) CREATE TABLE "s_emp" ( "id" INTEGER, "last_name" TEXT, "first_name" TEXT, "userid" TEXT, "start_date" TEXT,"comments" TEXT, "manager_id" TEXT, "title" CREATE TABLE "s_inventory" ("product_id" INTEGER, "warehouse_id" INTEGER, "amount_in_stock" INTEGER, "reorder_point" INTEGER, "max_in_stock" INTEGER CREATE TABLE "s_item" ( "ord_id" INTEGER, "item_id" INTEGER,"product_id" INTEGER, "price" REAL, "quantity" INTEGER, "quantity_shipped" INTEGER, FOREIGN CREATE TABLE "s_ord" ( "id" INTEGER, "customer_id" INTEGER, "date_ordered" TEXT, "date_shipped" TEXT, "sales_rep_id" INTEGER, "total" INTEGER, "payment CREATE TABLE "s_product" ( "id" INTEGER, "name" TEXT, "short_desc" TEXT, "suggested_whlsl_price" REAL, "whlsl_units" TEXT, PRIMARY KEY("id")) CREATE TABLE "s_region" ( "id" INTEGER, "name" TEXT, PRIMARY KEY("id")) CREATE TABLE "s_warehouse" ( "id" INTEGER, "region_id" INTEGER, "address" TEXT,"city" TEXT, "state" TEXT, "country" TEXT, "zip_code" TEXT, "phone" TEXT, UTF-8 H Type here to search O - a a W 33C ADO Dat 0 ENG 12:47 08-08-2021 DB Browser for SQLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Attach Database X Close Database Database Structure Edit Pragmas Execute SQL Browse Data Create Index Create Table Modify Table Delete Table Print Type Schema Name Tables (9) 5 customer Did name phone address city state country zip_code credit_rating sales_rep_id region_id comments 5 dept Did name region_id is emp id last_name first name userid start_date comments manager_id INTEGER TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT INTEGER TEXT CREATE TABLE 'S customer" ( "id" INTEGER, "name" TEXT, "phone" TEXT, "address" TEXT,"city" TEXT, "state" TEXT, "country" TEXT, "zip code" TEXT, "credit "id" INTEGER "name" TEXT "phone" TEXT "address" TEXT "city" TEXT "state" TEXT "country" TEXT "zip_code" TEXT "credit_rating" TEXT "zip_code" TEXT "sales_rep_id" TEXT "region_id" INTEGER "comments" TEXT CREATE TABLE "s_dept" ( "id" INTEGER, "name" TEXT, "region_id" INTEGER, FOREIGN KEY("region_id") REFERENCES "s_region"("id"), PRIMARY KEY("id")) "id" INTEGER "name" TEXT "region id" INTEGER CREATE TABLE "s_emp" ( "id" INTEGER, "last_name" TEXT, "first_name" TEXT,"userid" TEXT, "start_date" TEXT, "comments" TEXT, "manager_id" TEXT, "title "id" INTEGER "last_name" TEXT "first_name" TEXT "userid" TEXT "start_date" TEXT "comments" TEXT "manager_id" TEXT INTEGER TEXT INTEGER INTEGER TEXT TEXT TEXT TEXT TEXT TEXT UTF-8 H Type here to search o E: 1 a W 30C A a 0 0 ENG 12:43 08-08-2021 DB Browser for SQLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Altach Database X Close Database Database Structure Browse Data Execute SQL Edit Pragmas Print Create Table Create Index Name Type S_emp Did INTEGER last_name TEXT first_name TEXT userid TEXT start_date TEXT comments TEXT manager_id TEXT title TEXT dept_id INTEGER salary REAL commission_pct TEXT ms_inventory product_id INTEGER la warehouse_id INTEGER amount_in_stock INTEGER reorder_point INTEGER max_in_stock INTEGER out_of_stock_expl... TEXT restock_date TEXT s s_item ord id INTEGER item id INTEGER product id INTEGER price REAL quantity INTEGER Schema CREATE TABLE "s_emp" ( "id" INTEGER, "last_name" TEXT, "first_name" TEXT, "userid" TEXT, "start_date" TEXT,"comments" TEXT, "manager_id" TEXT, "title "id" INTEGER "last_name" TEXT "first_name" TEXT "userid" TEXT "start_date" TEXT "comments" TEXT "manager id" TEXT "title" TEXT "dept_id" INTEGER "salary" REAL "commission pct" TEXT CREATE TABLE "s_inventory" ("product_id" INTEGER, "warehouse_id" INTEGER, "amount_in_stock" INTEGER, "reorder_point" INTEGER, "max_in_stock" INTEG "product_id" INTEGER "Warehouse_id" INTEGER "amount_in_stock" INTEGER " "reorder_point" INTEGER "max in stock" INTEGER "out_of_stock_explanation" TEXT "restock_date" TEXT CREATE TABLE "s_item" ("ord_id" INTEGER, "item_id" INTEGER,"product_id" INTEGER, "price" REAL, "quantity" INTEGER, "quantity_shipped" INTEGER, FOREI "ord id" INTEGER "item id" INTEGER "product id" INTEGER "price" REAL "quantity" INTEGER UTF-8 H Type here to search o a a . w 33C ADO Dat 0 ENG 12:45 08-08-2021 DB Browser for SOLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Altach Dalabas X Close Database Database Structure Browse Data Execute So Edit Pragmas Print Create Table Create Index Schema .------ Name Type is_item ord id INTEGER item_id INTEGER product_id INTEGER price REAL quantity INTEGER quantity_shipped INTEGER s_ord Did INTEGER customer_id INTEGER date ordered TEXT date shipped TEXT sales repid INTEGER total INTEGER payment_type TEXT order_filled TEXT ms_product id INTEGER name TEXT short_desc TEXT suggested_whisl_... REAL whlsl_units TEXT > s_region > s_warehouse Indices (0) Views (0) CREATE TABLE "s_item" ("ord_id" INTEGER, "item_id" INTEGER,"product_id" INTEGER, "price" REAL, "quantity" INTEGER, "quantity_shipped" INTEGER, FOREI "ord_id" INTEGER "item_id" INTEGER "product_id" INTEGER "price" REAL "quantity" INTEGER "quantity_shipped" INTEGER "quantity' INTEGER CREATE TABLE "s_ord" ( "id" INTEGER, "customer_id" INTEGER, "date_ordered" TEXT, "date_shipped" TEXT, "sales_rep_id" INTEGER, "total" INTEGER, "payme "id" INTEGER "customer_id" INTEGER "date ordered" TEXT "date shipped" TEXT "sales rep id" INTEGER "total" INTEGER "payment type" TEXT "order_filled" TEXT CREATE TABLE "s_product" ( "id" INTEGER, "name" TEXT, "short_desc" TEXT, "suggested_whlsl_price" REAL, "whlsl_units" TEXT, PRIMARY KEY("id")) "id" INTEGER "name" TEXT "short_desc" TEXT "suggested_whlsl_price" REAL "whisl_units" TEXT e OneDrive CREATE TABLE "s_region" ( "id" INTEGER, "name" TEXT, PRIMARY KEY("id")) CREATE TABLE "s_warehouse" ( "id" INTEGER, "region_id" INTEGER, "address" TEXT, "city" TEXT," Screenshot saved The screenshot was added to your OneDrive. WIF-N H Type here to search 1 a c w 33C ADO Dat 0 ENG 12:46 08-08-2021 DB Browser for SQLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Altach Database X Close Database Database Structure Browse Data Edit Pragmas Execute SOL Create Table Create Index Print Type INTEGER INTEGER TEXT TEXT INTEGER TEXT TEXT REAL TEXT Name sales_rep_id total payment_type order_filled s_product id name short_desc suggested whlsl... whisl units s region Did name ms_warehouse id region_id address city state country zip_code phone manager_id Indices (0) Views (0) Triggers (0) Schema "sales_rep_id" INTEGER "total" INTEGER "payment_type" TEXT "order_filled" TEXT CREATE TABLE "s_product" ( "id" INTEGER, "name" TEXT, "short_desc" TEXT, "suggested_whlsl_price" REAL, "whlsl_units" TEXT, PRIMARY KEY("id")) "id"INTEGER "name" TEXT "short desc" TEXT "suggested whisl price REAL "whisl units" TEXT CREATE TABLE "s_region" ( "id" INTEGER, "name" TEXT, PRIMARY KEY("id")) "id" INTEGER "name" TEXT CREATE TABLE "s_warehouse" ( "id" INTEGER, "region_id" INTEGER, "address" TEXT, "city" TEXT, "state" TEXT, "country" TEXT, "zip_code" TEXT, "phone" TEX "id" INTEGER "region_id" INTEGER "address" TEXT "city" TEXT "state" TEXT "country" TEXT "zip code" TEXT "phone" TEXT "manager_id" INTEGER INTEGER TEXT INTEGER INTEGER TEXT TEXT TEXT TEXT TEXT TEXT INTEGER UTF-8 H Type here to search o a . W 33C AYO ENG 12:46 08-08-2021 DB Browser for SOLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Attach Database x Close Database Database Structure Browse Data Edit Pragmas Execute SOU Table: los customer 3 Hilter in any column Filter id name phone address city state country zip code credit rating sales rep id region id comments Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter 1 201 One Sport 55-112066222 82 Via Bahia Sao Paolo NULL Brazil MULL EXCELLENT 12 2 NULL 2 202 Deportivo Caracas 58-28066222 31 Sabana Grande Caracas NULL Venezuela WULZ EXCELLENT 12 2 NULL 3 203 New Delhi Sports 91-11903338 11368 Chanakya New Delhi NULL India YVULL GOOD 11 4 NULL 4 204 Ladysport 1-206-104-0111 281 Queen Street Seattle Washington US NULL EXCELLENT 11 1 NULL 5 205 Kim's Sporting Goods 852-3693888 15 Henessey Road Hong Kong NULL NULL NULZ EXCELLENT 11 4 NULL 6 206 Sportique 33-93425722253 172 Rue de Place Cannes NULL France NULL EXCELLENT 13 5 NULL 7 207 Tall Rock Sports 234-16036222 10 Saint Antoine Lagos MULA Nigeria NULL GOOD MULA 3 NULL 8 208 Muench Sports 49-895274449 435 Gruenestrasse Munich NVULZ Germany NULL GOOD 13 5 NULL 9 209 Beisbol Si! 809-352666 415 Playa Del Mar San Pedro de Macoris NULL Dominican Republic NULL EXCELLENT 11 6 NULL 10 210 Futbol Sonora 52-404555 5 Via Saguaro Nogales NULL Mexico NULL EXCELLENT 12 2 NULL 11 211 Helmut's Sports 42-2111222 45 Modrany Prague NULL Czechoslovakia NULL EXCELLENT 11 5 NULL 12 212 Hamada Sport 20-31209222 47A Corniche Alexandria NULL Egypt NULL EXCELLENT 13 3 NULL 13 213 Sports Emporium 1-415-555-6281 4783 168th Street San Francisco CA US NULL EXCELLENT 11 1 NULL 14 214 Sports Retail 1-716-555-7777 115 Main Street Buffalo NY US NULL POOR 11 1 NULL 15 215 Sports Russia 7-0953892444 7070 Yekatamina Saint Petersburg NULL Russia NULL POOR 11 5 NULL 16 301 Sports, Inc 540-123-4567 72 High St Harrisonburg VA US 22809 EXCELLENT 12 1 NULL 17 302 Toms Sporting Goods 540-987-6543 6741 Main St Harrisonburg VA US 22809 POOR 14 1 NULL 18 303 Athletic Attire 540-123-6789 54 Market St Harrisonburg VA US 22808 GOOD 14 1 NULL 19 304 Athletics For All 540-987-1234 286 Main St Harrisonburg VA US 22808 EXCELLENT 12 1 NULL N1-20 of 25 N Go to: : 1 66 85 UTF-8 H Type here to search EL j' - a a w 33C ADO Dat 0 ENG 12:47 08-08-2021 DB Browser for SQLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Attach Database x Close Database Database Structure Browse Data Edit Pragmas Execute SOU Table: as customer Hilter in any column Filter id name phone address city state Filter Filter Filter Filter Filter Filter 7 207 Tall Rock Sports 234-16036222 10 Saint Antoine Lagos NULL 8 208 Muench Sports 49-895274449 435 Gruenestrasse Munich NULL 9 209 Beisbol Si! 809-352666 415 Playa Del Mar San Pedro de Macoris NULL 10 210 Futbol Sonora 52-404555 5 Via Saguaro Nogales NULL 11 211 Helmut's Sports 42-2111222 45 Modrany Prague NULL 12 212 Hamada Sport 20-31209222 47A Corniche Alexandria NULL 13 213 Sports Emporium 1-415-555-6281 4783 168th Street San Francisco CA 14 214 Sports Retail 1-716-555-7777 115 Main Street Buffalo NY 15 215 Sports Russia 7-0953892444 7070 Yekatamina Saint Petersburg NULL 16 301 Sports, Inc 540-123-4567 72 High St Harrisonburg VA 17 302 Toms Sporting Goods 540-987-6543 6741 Main St Harrisonburg VA 18 303 Athletic Attire 540-123-6789 54 Market St Harrisonburg VA 19 304 Athletics For All 540-987-1234 286 Main St Harrisonburg VA 20 305 Shoes for Sports 540-123-9876 538 High St Harrisonburg VA 21 306 BJ Athletics 540-987-9999 632 Water St Harrisonburg VA 22 403 Athletics One 717-234-6786 912 Columbia Rd Lancaster PA 23 404 Great Athletes 717-987-2341 121 Litiz Pike Lancaster PA 24 405 Athletics Two 717-987-9875 435 High Rd Lancaster PA 25 406 Athletes Attic 717-234-9888 101 Greenfield Rd Lancaster PA 7- 25 of 25 N country zip code credit rating sales rep id region id comments Filter Filter Filter Filter Filter Nigeria NULL GOOD NULL 3 NULL Germany NULL GOOD 13 5 NULL Dominican Republic NULL EXCELLENT 11 6 NULL Mexico NULL EXCELLENT 12 2 NULL Czechoslovakia NULZ EXCELLENT 11 5 NULL Egypt NULL EXCELLENT 13 3 NULL US NULL EXCELLENT 11 1 NULL US YULZ POOR 11 1 NULL Russia NULL POOR 11 5 NULL US 22809 EXCELLENT 12 1 NULL US 22809 POOR 14 1 NULL US 22808 GOOD 14 1 NULL US 22808 EXCELLENT 12 1 NULL US 22809 EXCELLENT 14 1 NULL US 22810 POOR 12 1 NULL US 17601 GOOD US 17602 EXCELLENT OneDrive US 17602 EXCELLENT Screenshot saved US The screenshot was added to your Go to: 1 OneDrive. 17601 POOR H Type here to search o E - a 0 w 33C ADO Dat 0 ENG 12:47 08-08-2021 F File Database Interrogation week 8_398623285[4478] [Read-Only] - Word (Product Activation Faile.. Home Insert Insert Design Layout References Mailings Review View Tell me what you want to do... X Cut Calibri - 13 A A A A Aa A - Copy BIU - X, XA aty 1 Normal . A Format Painter Title 1 No Spac... Heading 1 Heading 2 Clipboard Font Paragraph Styles A AaBbCcDc AabbCcDc AaBbcc Aabbcct AaB Aabbccc AaBbccda AoBbcoda e Replace Sign in & Share Find - Select Paste Subtitle Subtle Em... Emphasis Editing Write SQL queries. Open the Company database in the SQLite Browser and create the following SQL queries: 1. For each warehouse display an address and country. 2. For each warehouse display a warehouse address, city, country, and a warehouse manager last name. In this query you need to use two tables: s_warehouse and s_emp. 3. Display all products with names starting from the letter 'B'. 4. Display last and first names of employees working at the department '41' and whose salaries are greater than $1000. 5. Display last and first names of employees whose title is NOT 'Stock Clerk'. 6. Display last names and titles of employees who started working after 1 January 2011. You need to follow to the 'Good practice style of SQL writing: Write SQL commands in capital letter where appropriate Use aliases for column names WHAT TO SUBMIT: 1. Copy and paste the queries in THIS MS Word document. For example: SELECT last_name AS LAST NAME], first_name AS [FIRST NAME] FROM s_emp 2. For each query, take a screen image of the output and paste it in THIS document Example: LAST NAME FIRST NAME Page 1 of 1 206 words [E English (Australia) 38 E + 100% 11 Type here to search o ii - a 3 6 w 28C DO 1a ENG 07:45 08-08-2021 File Paste Database Interrogation week 8_398623285[4478] [Read-Only] - Word (Product Activation Failed) F Home Insert Design Layout References Mailings Review View Tell me what you want to do... Sign in & Share of Cut Find - Times New R 12 AA Aa A AED AT 2117 AaBbccdc AaBbccdc AaBbcc Aabbccc AaB AalbCcc AaBbccda Abbcca al Replace - Copy BIU E X, X? A aty 1 Normal Title 1 No Spac... Heading 1 Heading 2 Subtitle Subtle Em... Emphasis Format Painter Select Clipboard Paragraph Styles Editing A WHAT TO SUBMIT: 1. Copy and paste the queries in THIS MS Word document. For example: Font SELECT last_name AS [LAST NAME], first_name AS [FIRST NAMEJ FROM s emp 2. For each query, take a screen image of the output and paste it in THIS document Example: LAST NAME FIRST NAME Martin Carmen 1 2 Smith Doris 3 Norton Michael 4 Quentin Mark 5 Roper Joseph 6 Brown Molly 7 Hawkins Roberta 8 8 Burns Ben Execution finished without errors. Result: 25 rows returned in 13m3 At line 1: SELECT last_name AS (LAST NAME], first_name AS [FIRST NAME] FROM #_exp Submit your solution to Database Interrogation Assessment in Canvas Page 1 of 1 206 words [English (Australia) 38 E + 100% 11 Type here to search O DI a WE 29C ADO 1a ENG 07:48 08-08-2021