Walmart (www.walmart.com) is one of the leading retailers in the…

ConstableAlligator2119 Walmart (www.walmart.com) is one of the leading retailers in the…Walmart (www.walmart.com) is one of the leading retailers in the world with no dedicated loyalty program (ignore the hybrid program). Although many retailing giants are leveraging the data on their customers, Walmart remains in the dark. Meanwhile, Walmart faces fierce competition amid Covid-19 pandemic from the online retailers like Amazon and Alibaba who completely rely on data-driven decision making. Assume that you are a newly hired Business Analyst by Walmart; and you are planning to implement a new customer royalty card program to improve Walmart’s business data-driven decision making (DDDM). The example of such the customer royalty card dataset looks as follow with 5 basic features (see below table) and the actual dataset in MS Excel is also given. 1) Customer ID: an unique sequential number to identify a customer based on the card issued date. 2) Gender: male or female, claimed by the customer. 3) Age: based on a required government issued ID: date of the birth. 4) Annual income: based on the customer claimed annual income in thousand dollars (000s); e.g., 15 means $15,000. 5) Spending score: based on the previous accumulated purchase value and normalized from 1 to 100 Please write 4 SQL statements (Handwriting is required, please include a photo image here) to query the following and execute the SQL over SQL Lite (https://www.sqlite.org/download.html), please screen shot the results here:   a) What is Average Income for this Walmart’s customers? b) What is Percentage of Female customers in this Walmart store? c) What is Average spending score for Female customers in this Walmart store? d) What are Total spending scores for Female customers who are age between 20 and 30 years old in this store? Image transcription text19 20 21 22 23 24 25 26 27 28 29 30 $1 32 33 $4 35 $6 18 Male19 Male 20 Female 21 Male 22 Male 23 Female 24 Male 25Female 26 Male 27 Female 28 Male 29 Female 30 Fem… Show more… Show moreImage transcription text37 38 39 10 1’1 12 13 14 15 16 17 18 19 SO 31 32 S3 S4 36Female 37 Female 38 Female 39 Female 40 Female 41 Female 42Male 43 Male 44 Female 45 Female 46 Female 47 Fem… Show more… Show moreImage transcription text55 S6 S7 58 59 SO 31 32 33 i4 35 36 i7 38 39 ‘0 ‘1 ‘2 54 Male 55Female 56 Male 57 Female 58 Male 59 Female 60 Male 61 Male62 Male 63 Female 64 Female 65 Male 66 Male 67 Fe… Show more… Show moreImage transcription text73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 9D 72Female 73 Female 74 Female 75 Male 76 Male 77 Female 78 Male79 Female 80 Female 81 Male 82 Male 83 Male 84 Fe… Show more… Show moreImage transcription text31 32 33 34 35 36 37 38 39 00 0’1 02 03 04 05 06 07 08 90Female 91 Female 92 Male 93 Male 94 Female 95 Female 96 Male97 Female 98 Female 99 Male 100 Male 101 Female 1… Show more… Show moreImage transcription textIAU 1Ur 103 103 110 111 112 113 114 115 116 11? 113 113 120121 122 123 124 125 126 12? 123 123 130 131 132 133 134135 136 13? 133 133 140 141 142 143 144 145 146 … Show more… Show moreImage transcription text155 156 15? 158 153 160 161 162 163 16-1 165 166 16T 166163 1T0 1T1 1T2 1T3 1T4 1T5 1T6 1TT 1T6 1T3 160 161 182163 16-1 165 166 18T 166 163 130 131 132 133 13-… Show more… Show more BusinessBusiness – Other