Before the insights, comes the cleanup Just wrapped up a data cleaning project from messy rows to ready for analysis data! #DataAnalytics #DataCleaning #sqlfiltering #SQLServer"

Day 12 of #20dayswithdata Challenge: Write an SQL query to retrieve orders made by a specific customer. I filtered the result. #hertechtrailacademy and #HTTDataChallenge, #SQLFiltering , #DataQuerying.

Day 12: Filtering Data Orders for customer with Id 1021, having total of 10 orders from 12th Oct 2015 to 9th February 2016. #SQLFiltering #Dataquerying #20dayswithdatachallenge #hertechtrailacademy

Day 12: SQL Query to retrieve orders made by a customer I wrote a query to retrieve orders made by customer with account ID: 1001 Results show that the customer has made 28 orders in total #20dayswithdata #hertechtrailacademy #HTTDDatachallenge #SQLFiltering

Day 12 of #20dayswithdata Filtered the data to retrieve orders detailing customer name, account id, when the purchase occurred, total products and total amount of purchase. #SQL #MySQL #SQLFiltering #DataQuerying

Day 12- Filtering Data I wrote an SQL query to retrieve orders made by a customer with account id 1061. The customer made 6 orders. #20dayswithdata #SQLFiltering #DataQuerying.

Day 12 of #20dayswithdata. Today's task was to retrieve orders made by a specific customer (in my case, the customer with account_id 1021) by filtering the dataset using the WHERE statement. Results show that the customer placed ten orders between 2015 and 2016. #SQLFiltering

Day 12 #20dayswithdata Filtering Data Write an SQL query to retrieve orders made by a specific customer @hertechtrail #SQLFiltering #DataQuerying.

Day 12: Filtering data. I used the WHERE query to filter the order made by the account_id - 1011. #20dayswithdata #SQLFiltering #DataQuerying @hertechtrail

Day 12: Filtering Data Challenge: Write an SQL query to retrieve orders made by a specific customer. #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLFiltering #DataQuerying

Day 12 of 20. Task: Write a query to retrieve orders made by a specific customer. #hertechtrailacademy #HTTDataChallenge #20dayswithdata #SQLFiltering #SQLQuerying

Day 13 I retrieved orders made by customers, sorting it by customer name in alphabetical order using ORDER clause. @hertechtrail @phaibooboo #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLFiltering

Day 12 #20dayswithdata I wrote an SQL query to retrieve all orders made by the customer with account id "1101". From the result, the customer has placed about 19 orders between 21st September and 13th May 2016. #SQLFiltering #SQLQuerying

Day 12/20: Write an SQL query to retrieve orders made by a specific customer. #Better_Late_Than_Never #20dayswithdata, #hertechtrailacademy, #SQLFiltering @phaibooboo @ImaNjokko @AtiJoshua @vicSomadina @fresh_gb @OMOTOSHOOLAMI15

Day 12: Filtering Data Using the JOIN clause combines data from the orders and accounts tables @phaibooboo @ImaNjokko @fresh_gb @vicSomadina @AtiJoshua @OMOTOSHOOLAMI15 #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLFiltering #DataQuerying

Day 12: Filtering Data Retrieve all orders made by customer with account id: 1001 #20dayswithdata #SQLFiltering #DataQuerying

Day 12: Filtering data - Write an SQL query to retrieve orders made by a specific customer. #SQL #DataQuerying #SqlFiltering #20dayswithdata,#hertechtrail,#HTTDataChallenge @phaibooboo,@ImaNjokko @vicSomadina

Day 12:#20dayswithdata Task: Write an SQL query to retrieve orders made by a specific customer. #20dayswithdata, #hertechtrailacademy #HTTDataChallenge #SQLFiltering #DataQuerying. @phaibooboo , @ImaNjokko , @fresh_gb , @vicSomadina , @AtiJoshua , @OMOTOSHOOLAMI15

Day 12 #SQLFiltering I retrieved orders from customers with their id. SELECT * FROM orders WHERE account id= 1091 SELECT* FROM orders WHERE account id = 1301 @hertechtrail @Rita_tyna @phaibooboo #20dayswithdata #hertechtrailacademy #HTTDataChallenge #DataQuerying

Day 12 I selected all columns for a specific customer using the where clause to filter the records with customer id from a table named Orders$ @hertechtrail @phaibooboo #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLFiltering #DataQuerying