Question: Please help me with this assignment In this project you will build a database for a public library. This database is aimed to collect and
Please help me with this assignment
In this project you will build a database for a public library. This database is aimed to collect and analyze information about the clients' reading interests. The project concentrates only on books and the clients' interests in books. The analyses that will result from this project will be used by the library's management to decide on the future purchasing policy.
A. Write the SQL statements in order to create the tables for the database. Use the Entity Relationship Diagram (ERD) of the database shown in Figure 1. For simplicity, we are assuming in this project that a book cannot be written by more than one author. You need to create the tables as well as the required constraints, including the keys (primary and foreign), and the relationships between tables.
B. Populate your database with the sample set of data given to you in the tables below the assignment prompts.
C. Write the following queries to retrieve the information detailed below.
- Display all contents of the Clients table
- First names, last names, ages and occupations of all clients
- First and last names of clients that borrowed books in March 2018
- First and last names of the top 5 authors clients borrowed in 2017
- Least 5 author nationalities clients borrowed during the years 2015-2017
- The book that was most borrowed during the years 2015-2017
- Top borrowed genres for client born in years 1970-1980
- Top 5 occupations that borrowed the most in 2016
- Average number of borrowed books by job title
- Create a VIEW and display the titles that were borrowed by at least 20% of clients
- The top month of borrows in 2017
- Average number of borrows by age
- The oldest and the youngest clients of the library
- First and last names of authors that wrote books in more than one genre
As you work on these queries, create indexes that will increase your queries' performance.
You must include comments in your code that address the purpose of your query and explains each step. Save your queries and results in a plain-text file that you will submit as your assignment.







Borrow Barrower Borowid Clienti Booked BorrowDate Client Chendid ClientFirstame Call atNutriu Cliento Occupation Borrowed By Wit Book Bookid Book Title BookAuthor Genre Author Authorld Author Frame Authoritate AuthorNationality Figure 1: ERD for Library Database Author table: Authorld Author FirstName Author LastName AuthorNationality 1 Sofia Smith Canada N Maria Brown Brazil 3 Elena Martin Mexico 4 Zoe Roy France 5 Sebastian Lavoie Canada 6 Dylan Garcia Spain 7 lan Cruz Mexico Lucas Smith USA 8 9 Fabian Wilson USA 10 Liam Canada Taylor Thomas 11 William Great Britain 12 Moore Canada Logan Oliver 13 Martin France 14 Alysha Thompson Canada 15 Isabelle Lee Canada 16 Emily Clark USA 17 John Young China 18 David Wright Canada 19 Thomas Scott Canada 20 Helena Adams Canada 21 Sofia Carter USA 22 Liam Parker Canada 23 Emily Murphy USA 1 1 3 3 4 5 5 7 6 7 8 9 CON 10 9 12 11 13 14 1 15 13 Book table: BookID BookTitle BookAuthor Genre Build your database system Science 2 The red wall 2 Fiction The perfect match Fiction 4 Digital Logic Science How to be a great lawyer Law 6 Manage successful negotiations 6 Society 7 Pollution today Science A gray park Fiction 9 How to be rich in one year 8 Humor Their bright fate Fiction 11 Black lines 10 Fiction History of theater Literature Electrical transformers 12 Science Build your big data system Science Right and left Children 16 Programming using Python 1 Science Computer networks Science Performance evaluation Science Daily exercise Well being 20 The silver uniform 17 Fiction Industrial revolution History 22 Green nature 19 Well being Perfect football Well being The chocolate love Humor 25 Director and leader Society Play football every week well being 27 Maya the bee 13 Children Perfect rugby Well being 29 The end Fiction Computer security Science Participate Society 32 Positive figures Fiction 17 14 18 15 19 16 21 18 23 20 24 21 22 26 20 28 20 23 30 1 31 22 3 1 Client table: Clientid ClientFirstName ClientLastName ClientDoB Occupation Kaiden Hill 2006 Student 2 Alina Morton Student Brooks 1983 Food Scientist Courtney Jensen 2006 Student Brittany Hill 1983 Firefighter 2010 3 Fania 4 5 6 Max Rogers 2005 Student 7 1981 School Psychologist Margaret Julie 8 1973 Professor McCarthy McCarthy McCarthy O'Quinn 9 Ken 1974 Securities Clerk 10 Britany 1984 Violinist 11 Conner Gardner 1998 Licensed Massage Therapist Parquet Floor Layer 12 Mya Austin 1960 13 Thierry Rogers 2004 Student 14 Eloise Rogers 1984 15 Gerard Jackson 1979 16 1986 Randy Jodie Day Page 17 1990 Computer Security Manager Oil Exploration Engineer Aircraft Electrician Manufacturing Director Window Washer Student Repair Worker Police Officer 18 Coral Rice 1996 19 Ayman Austin 2002 20 Jaxson Austin 1999 21 Joel 1973 22 Alina Austin Austin Austin 2010 Student 23 Elin 1962 Payroll Clerk 24 Ophelia Wolf 2004 Student 25 Eliot McGuire 1967 Dentist 26 Peter 1968 Professor McKinney Henry 27 Annabella 1974 Nurse 28 Anastasia Baker 2001 Student 29 Tyler Baker 1984 Police Officer 30 Lilian Ross 1983 Insurance Agent 31 Thierry Arnold 1975 Bus Driver 32 Angelina Rowe 1979 Firefighter 33 Marcia Rowe 1974 Health Educator 34 Martin Rowe 1976 Ship Engineer 35 Adeline Rowe 2005 Student 35 Adeline Rowe 2005 Student 36 Colette Rowe 1963 Professor 37 Diane Clark 1975 Payroll Clerk 38 Caroline Clark 1960 Dentist 39 Dalton Clayton 1982 40 Steve Clayton 1990 Police Officer Bus Driver Computer Engineer 41 Melanie Clayton 1987 42 Alana Wilson 2007 Student 43 Carson Byrne 1995 Food Scientist 44 Conrad Byrne 2007 Student 45 Ryan Porter 2008 Student 46 Elin Porter 1978 Computer Programmer 47 Tyler Harvey 2007 Student 48 Arya 2008 Student 49 Serena 1978 Harvey Harvey Franklin Franklin School Teacher Doctor 50 Lilly 1976 51 Mai 1994 Dentist 52 John Franklin 1999 Firefighter 53 Judy Franklin 1995 54 Katy Lloyd 1992 55 Tamara Allen 1963 Firefighter School Teacher Ship Engineer Police Officer Computer Engineer School Teacher 56 Maxim Lyons 1985 57 Allan Lyons 1983 58 Marc Harris 1980 59 Elin Young 2009 Student 60 Diana Young 2008 Student 61 Diane Young 2006 Student 62 Alana Bird 2003 Student 63 Anna Becker 1979 Security Agent Manager 64 Katie Grant 1977 65 Joan Grant 2010 Student 66 Bryan Bell 2001 Student 67 Belle Miller 1970 Professor 68 Peggy Stevens 1990 Bus Driver 69 Steve Williamson 1975 HR Clerk 70 Tyler Williamson 1999 Doctor 71 Izabelle Williamson 1990 Systems Analyst 72 Annabel Williamson 1960 Cashier 73 Mohamed Waters 1966 Insurance Agent Computer Programmer 74 Marion 1970 Newman Williams 75 Ada 1986 Computer Programmer 76 Sean Scott 1983 Bus Driver 77 Farrah Scott 1974 Ship Engineer School Teacher 78 Christine Lambert 1973 79 Alysha Lambert 2007 Student 80 Mala Grant 1984 School Teacher N 19 15 9 17 7 26 27 21 8 18 26 28 18 13 6 13 17 18 3 12 30 23 1 25 24 15 13 1 24 22 10 11 32 11 13 22 23 Borrower table: Borrowl Clienti Bookld Borrox Date 1 1 35 17 20/07/2016 49 2 1 3 19/04/2017 50 3 42 18 3/10/2016 51 4 62 16 5/4/2016 52 5 53 13 17/01/2017 53 6 33 15 26/11/2015 54 7 40 14 21/01/2015 55 8 64 12 10/9/2017 56 9 56 30 2/8/2017 57 10 23 2 28/06/2018 58 11 46 19 18/11/2015 59 12 61 20 24/11/2015 60 13 58 7 17/06/2017 61 14 46 16 12/2/2017 62 15 80 21 18/03/2018 63 16 51 23 1/9/2015 64 17 49 18 28/07/2015 65 18 43 18 4/11/2015 66 19 30 2 10/8/2018 167 20 48 24 13/05/2015 68 21 71 5 5/9/2016 69 22 35 3 3/7/2016 70 57 1 1 17/03/2015 71 24 23 25 16/08/2017 72 25 20 12 24/07/2016 73 26 25 7 31/01/2015 74 27 72 29 10/4/2016 75 28 74 20 31/07/2017 76 29 53 14 20/02/2018 77 30 32 10 24/07/2017 78 31 12 15 25/04/2018 79 32 77 13 9/6/2017 80 33 30 4 24/10/2017 81 34 37 24 14/01/2016 82 35 27 26 5/6/2017 83 36 1 16 6/5/2018 84 37 21 9 19/03/2016 85 38 69 28 29/03/2017 86 39 17 19 14/03/2017 87 40 8 19 22/04/2016 88 41 63 18 25/01/2015 89 42 65 20 10/10/2016 90 43 51 19 28/07/2015 91 44 23 12 25/01/2017 92 45 17 4 4 18/04/2017 93 46 68 5 6/9/2016 94 47 46 13 30/09/2017 95 48 15 13 5/7/2017 96 97 98 99 100 11 78 47 68 37 48 9 29 64 61 39 73 11 45 33 10 28 51 29 28 74 15 57 2 74 51 25 45 27 32 71 75 56 26 66 57 40 65 54 29 44 56 17 35 22 39 63 53 40 52 27 72 20 22 8 5 12 10 17 21 25 28 121 26 32 32 32 18 15 4 7 4 9 31 4 16 18 24 14 21 19 4 20 29 14/12/2017 101 26/01/2017 102 3/3/2015 103 26/05/2016 104 6/2/2017 105 30/12/2015 106 21/10/2017 107 1/4/2018 108 29/08/2017 109 21/02/2018 110 26/07/2016 111 22/08/2018 112 17/01/2018 113 20/07/2016 114 18/03/2018 115 6/6/2016 116 17/02/2017 117 9/12/2016 118 18/09/2015 119 14/09/2017 120 12/12/2015 121 14/01/2015 122 20/08/2017 123 18/01/2015 124 14/04/2018 125 25/02/2016 126 24/02/2015 127 10/2/2017 128 3/8/2016 129 15/06/2016 130 21/05/2017 131 3/5/2016 132 23/12/2015 133 16/05/2015 134 30/05/2015 135 15/09/2017 136 2/9/2016 137 17/08/2017 138 19/12/2015 139 22/07/2017 140 31/12/2017 141 13/06/2015 142 1/4/2015 143 19/07/2018 144 22/06/2017 145 29/05/2015 146 20/01/2018 147 31/07/2016 148 10/7/2016 149 5/4/2017 150 4/9/2016 6/12/2015 49 6 74 48 69 60 45 42 79 70 34 43 42 67 80 54 34 65 61 38 51 7 46 75 72 44 68 21 14 68 35 16 79 14 29 41 42 45 36 36 54 61 1 43 37 62 50 45 32 13 16 12 31 32 2 32 22 15 8 18 8 8 32 15 25 11 28 20 19 12 4 16 16 30 32 17 15 1 25 21 20 27 31 17 28 4 13 3 16 30 32 15 13 1 14 17 22 11 17 28 19/12/2017 151 4/12/2016 152 27/07/2016 153 29/06/2016 154 27/12/2016 155 29/10/2017 156 12/6/2017 157 14/05/2017 158 13/10/2016 159 4/12/2016 160 6/3/2016 161 19/12/2015 162 20/04/2016 163 6/3/2017 164 23/06/2015 165 3/5/2017 166 30/08/2017 167 26/08/2017 168 5/1/2018 169 17/01/2018 170 13/05/2016 171 17/03/2016 172 25/11/2016 173 12/8/2018 174 12/3/2015 175 15/06/2015 176 21/02/2016 177 19/06/2016 178 10/10/2016 179 27/05/2016 180 19/03/2015 181 8/8/2016 182 7/3/2018 183 28/04/2018 184 11/3/2018 185 8/8/2018 186 23/02/2016 187 10/7/2017 188 19/07/2018 189 7/8/2015 14/03/2018 191 28/03/2017 192 17/05/2018 193 14/05/2015 194 30/07/2015 195 19/09/2015 196 2/12/2016 197 24/07/2016 198 10/3/2018 199 14/02/2016 200 15 10 66 68 21 35 17 40 1 70 80 29 76 22 2 35 40 68 32 34 34 80 20 36 78 57 75 71 48 19 79 70 30 45 30 26 66 47 53 80 70 14 46 30 60 14 71 38 69 49 9 19 3 29 14 19 24 21 24 27 26 5 12 4 2 13 8 19 5 17 16 30 32 10 12 18 11 10 22 16 30 13 6 12 27 13 16 15 30 16 13 25 22 132 14 13 15 21 30 31 11/8/2018 201 29/08/2018 202 27/11/2016 203 12/7/2017 204 27/06/2018 205 22/01/2016 206 25/08/2016 207 9/7/2015 208 28/03/2016 209 10/7/2015 210 24/04/2016 211 18/10/2015 212 25/04/2018 213 24/12/2016 214 26/10/2017 215 28/02/2016 216 2/10/2017 217 3/1/2016 218 13/11/2016 219 15/09/2016 220 13/04/2018 221 13/10/2016 222 17/11/2015 223 1/9/2017 224 27/06/2018 225 22/03/2016|226 27/06/2017 227 1/8/2015 228 29/09/2015 229 21/02/2016|230 20/08/2018 231 16/09/2016 232 10/2/2017 233 12/10/2017 234 23/11/2016 235 13/08/2016 236 14/01/2017 237 10/2/2016 238 8/8/2018 239 31/03/2016 240 3/2/2018 241 27/03/2016|242 13/01/2016 243 6/8/2015 244 27/11/2016 245 23/05/2018 246 22/06/2016 247 27/12/2015248 29/04/2017 249 3/6/2018 250 28 49 75 78 43 27 64 21 66 45 48 20 41 51 5 5 40 79 15 42 17 38 79 74 46 78 45 72 18 29 66 36 26 32 62 12 38 29 36 76 28 60 8 25 62 51 27 69 51 17 31 28 3 1 3 18 21 22 11 29 13 30 25 20 12 1 13 4 10 122 19 13 2 13 18 22 2 31 17 3 11 16 12 1 14 4 32 16 25 7 16 13 3 1 29 18 23 12 12 4 15 29/05/2015 251 30/08/2016 252 29/10/2015 253 12/5/2017 254 25/03/2015 255 22/02/2016 256 3/4/2015 257 9/12/2017 258 20/12/2016 259 15/04/2017 260 31/01/2015 261 20/12/2017 262 29/01/2018 263 5/7/2015 264 12/4/2015 265 24/02/2018 266 27/06/2018 267 1/11/2016 268 28/12/2016 269 29/01/2018 270 9/5/2016 271 6/12/2017 272 7/12/2015 273 5/6/2016 274 11/8/2018 275 20/04/2015 276 11/11/2015 277 21/03/2015 278 13/08/2017 279 5/6/2018 280 28/04/2016 281 23/10/2016 282 31/10/2017 283 25/07/2017 284 8/7/2015 285 24/02/2015 286 28/07/2016 287 7/5/2017 288 13/06/2015 289 15/08/2016 290 26/08/2016 291 28/07/2017 292 30/07/2016 293 24/08/2018 294 1/9/2016 295 8/2/2015 296 25/06/2018 297 4/7/2015 298 1/5/2015 299 29/10/2017 300 14 14 39 79 40 51 61 15 10 67 79 19 35 27 30 8 70 56 13 61 47 30 18 34 32 19 62 44 27 61 5 43 34 35 13 74 70 42 51 45 70 77 74 47 10 16 48 72 26 49 7 9 18 19 2 13 22 22 29 21 28 24 22 5 28 13 19 19 5 12 18 31 17 24 30 17 7 25 14 2 21 5 3 23 23 15/01/2015 21/05/2018 26/12/2015 31/05/2016 18/03/2016 13/04/2018 11/2/2015 2/3/2018 21/01/2018 8/7/2017 11/12/2016 4/5/2016 1/8/2017 15/12/2017 22/12/2015 26/06/2015 20/03/2016 29/01/2016 6/3/2015 18/06/2016 18/09/2017 19/02/2016 31/12/2016 27/10/2017 3/6/2015 30/03/2016 23/03/2015 29/04/2017 25/03/2015 14/07/2017 4/12/2016 15/03/2018 5/6/2016 19/02/2018 23/09/2016 26/12/2016 15/08/2017 15/06/2016 30/07/2018 15/01/2015 7/10/2017 6/1/2017 25/09/2015 1/2/2018 18/04/2017 3/10/2016 17/09/2016 10/2/2017 1/3/2016 25/10/2016 190 Borrow Barrower Borowid Clienti Booked BorrowDate Client Chendid ClientFirstame Call atNutriu Cliento Occupation Borrowed By Wit Book Bookid Book Title BookAuthor Genre Author Authorld Author Frame Authoritate AuthorNationality Figure 1: ERD for Library Database Author table: Authorld Author FirstName Author LastName AuthorNationality 1 Sofia Smith Canada N Maria Brown Brazil 3 Elena Martin Mexico 4 Zoe Roy France 5 Sebastian Lavoie Canada 6 Dylan Garcia Spain 7 lan Cruz Mexico Lucas Smith USA 8 9 Fabian Wilson USA 10 Liam Canada Taylor Thomas 11 William Great Britain 12 Moore Canada Logan Oliver 13 Martin France 14 Alysha Thompson Canada 15 Isabelle Lee Canada 16 Emily Clark USA 17 John Young China 18 David Wright Canada 19 Thomas Scott Canada 20 Helena Adams Canada 21 Sofia Carter USA 22 Liam Parker Canada 23 Emily Murphy USA 1 1 3 3 4 5 5 7 6 7 8 9 CON 10 9 12 11 13 14 1 15 13 Book table: BookID BookTitle BookAuthor Genre Build your database system Science 2 The red wall 2 Fiction The perfect match Fiction 4 Digital Logic Science How to be a great lawyer Law 6 Manage successful negotiations 6 Society 7 Pollution today Science A gray park Fiction 9 How to be rich in one year 8 Humor Their bright fate Fiction 11 Black lines 10 Fiction History of theater Literature Electrical transformers 12 Science Build your big data system Science Right and left Children 16 Programming using Python 1 Science Computer networks Science Performance evaluation Science Daily exercise Well being 20 The silver uniform 17 Fiction Industrial revolution History 22 Green nature 19 Well being Perfect football Well being The chocolate love Humor 25 Director and leader Society Play football every week well being 27 Maya the bee 13 Children Perfect rugby Well being 29 The end Fiction Computer security Science Participate Society 32 Positive figures Fiction 17 14 18 15 19 16 21 18 23 20 24 21 22 26 20 28 20 23 30 1 31 22 3 1 Client table: Clientid ClientFirstName ClientLastName ClientDoB Occupation Kaiden Hill 2006 Student 2 Alina Morton Student Brooks 1983 Food Scientist Courtney Jensen 2006 Student Brittany Hill 1983 Firefighter 2010 3 Fania 4 5 6 Max Rogers 2005 Student 7 1981 School Psychologist Margaret Julie 8 1973 Professor McCarthy McCarthy McCarthy O'Quinn 9 Ken 1974 Securities Clerk 10 Britany 1984 Violinist 11 Conner Gardner 1998 Licensed Massage Therapist Parquet Floor Layer 12 Mya Austin 1960 13 Thierry Rogers 2004 Student 14 Eloise Rogers 1984 15 Gerard Jackson 1979 16 1986 Randy Jodie Day Page 17 1990 Computer Security Manager Oil Exploration Engineer Aircraft Electrician Manufacturing Director Window Washer Student Repair Worker Police Officer 18 Coral Rice 1996 19 Ayman Austin 2002 20 Jaxson Austin 1999 21 Joel 1973 22 Alina Austin Austin Austin 2010 Student 23 Elin 1962 Payroll Clerk 24 Ophelia Wolf 2004 Student 25 Eliot McGuire 1967 Dentist 26 Peter 1968 Professor McKinney Henry 27 Annabella 1974 Nurse 28 Anastasia Baker 2001 Student 29 Tyler Baker 1984 Police Officer 30 Lilian Ross 1983 Insurance Agent 31 Thierry Arnold 1975 Bus Driver 32 Angelina Rowe 1979 Firefighter 33 Marcia Rowe 1974 Health Educator 34 Martin Rowe 1976 Ship Engineer 35 Adeline Rowe 2005 Student 35 Adeline Rowe 2005 Student 36 Colette Rowe 1963 Professor 37 Diane Clark 1975 Payroll Clerk 38 Caroline Clark 1960 Dentist 39 Dalton Clayton 1982 40 Steve Clayton 1990 Police Officer Bus Driver Computer Engineer 41 Melanie Clayton 1987 42 Alana Wilson 2007 Student 43 Carson Byrne 1995 Food Scientist 44 Conrad Byrne 2007 Student 45 Ryan Porter 2008 Student 46 Elin Porter 1978 Computer Programmer 47 Tyler Harvey 2007 Student 48 Arya 2008 Student 49 Serena 1978 Harvey Harvey Franklin Franklin School Teacher Doctor 50 Lilly 1976 51 Mai 1994 Dentist 52 John Franklin 1999 Firefighter 53 Judy Franklin 1995 54 Katy Lloyd 1992 55 Tamara Allen 1963 Firefighter School Teacher Ship Engineer Police Officer Computer Engineer School Teacher 56 Maxim Lyons 1985 57 Allan Lyons 1983 58 Marc Harris 1980 59 Elin Young 2009 Student 60 Diana Young 2008 Student 61 Diane Young 2006 Student 62 Alana Bird 2003 Student 63 Anna Becker 1979 Security Agent Manager 64 Katie Grant 1977 65 Joan Grant 2010 Student 66 Bryan Bell 2001 Student 67 Belle Miller 1970 Professor 68 Peggy Stevens 1990 Bus Driver 69 Steve Williamson 1975 HR Clerk 70 Tyler Williamson 1999 Doctor 71 Izabelle Williamson 1990 Systems Analyst 72 Annabel Williamson 1960 Cashier 73 Mohamed Waters 1966 Insurance Agent Computer Programmer 74 Marion 1970 Newman Williams 75 Ada 1986 Computer Programmer 76 Sean Scott 1983 Bus Driver 77 Farrah Scott 1974 Ship Engineer School Teacher 78 Christine Lambert 1973 79 Alysha Lambert 2007 Student 80 Mala Grant 1984 School Teacher N 19 15 9 17 7 26 27 21 8 18 26 28 18 13 6 13 17 18 3 12 30 23 1 25 24 15 13 1 24 22 10 11 32 11 13 22 23 Borrower table: Borrowl Clienti Bookld Borrox Date 1 1 35 17 20/07/2016 49 2 1 3 19/04/2017 50 3 42 18 3/10/2016 51 4 62 16 5/4/2016 52 5 53 13 17/01/2017 53 6 33 15 26/11/2015 54 7 40 14 21/01/2015 55 8 64 12 10/9/2017 56 9 56 30 2/8/2017 57 10 23 2 28/06/2018 58 11 46 19 18/11/2015 59 12 61 20 24/11/2015 60 13 58 7 17/06/2017 61 14 46 16 12/2/2017 62 15 80 21 18/03/2018 63 16 51 23 1/9/2015 64 17 49 18 28/07/2015 65 18 43 18 4/11/2015 66 19 30 2 10/8/2018 167 20 48 24 13/05/2015 68 21 71 5 5/9/2016 69 22 35 3 3/7/2016 70 57 1 1 17/03/2015 71 24 23 25 16/08/2017 72 25 20 12 24/07/2016 73 26 25 7 31/01/2015 74 27 72 29 10/4/2016 75 28 74 20 31/07/2017 76 29 53 14 20/02/2018 77 30 32 10 24/07/2017 78 31 12 15 25/04/2018 79 32 77 13 9/6/2017 80 33 30 4 24/10/2017 81 34 37 24 14/01/2016 82 35 27 26 5/6/2017 83 36 1 16 6/5/2018 84 37 21 9 19/03/2016 85 38 69 28 29/03/2017 86 39 17 19 14/03/2017 87 40 8 19 22/04/2016 88 41 63 18 25/01/2015 89 42 65 20 10/10/2016 90 43 51 19 28/07/2015 91 44 23 12 25/01/2017 92 45 17 4 4 18/04/2017 93 46 68 5 6/9/2016 94 47 46 13 30/09/2017 95 48 15 13 5/7/2017 96 97 98 99 100 11 78 47 68 37 48 9 29 64 61 39 73 11 45 33 10 28 51 29 28 74 15 57 2 74 51 25 45 27 32 71 75 56 26 66 57 40 65 54 29 44 56 17 35 22 39 63 53 40 52 27 72 20 22 8 5 12 10 17 21 25 28 121 26 32 32 32 18 15 4 7 4 9 31 4 16 18 24 14 21 19 4 20 29 14/12/2017 101 26/01/2017 102 3/3/2015 103 26/05/2016 104 6/2/2017 105 30/12/2015 106 21/10/2017 107 1/4/2018 108 29/08/2017 109 21/02/2018 110 26/07/2016 111 22/08/2018 112 17/01/2018 113 20/07/2016 114 18/03/2018 115 6/6/2016 116 17/02/2017 117 9/12/2016 118 18/09/2015 119 14/09/2017 120 12/12/2015 121 14/01/2015 122 20/08/2017 123 18/01/2015 124 14/04/2018 125 25/02/2016 126 24/02/2015 127 10/2/2017 128 3/8/2016 129 15/06/2016 130 21/05/2017 131 3/5/2016 132 23/12/2015 133 16/05/2015 134 30/05/2015 135 15/09/2017 136 2/9/2016 137 17/08/2017 138 19/12/2015 139 22/07/2017 140 31/12/2017 141 13/06/2015 142 1/4/2015 143 19/07/2018 144 22/06/2017 145 29/05/2015 146 20/01/2018 147 31/07/2016 148 10/7/2016 149 5/4/2017 150 4/9/2016 6/12/2015 49 6 74 48 69 60 45 42 79 70 34 43 42 67 80 54 34 65 61 38 51 7 46 75 72 44 68 21 14 68 35 16 79 14 29 41 42 45 36 36 54 61 1 43 37 62 50 45 32 13 16 12 31 32 2 32 22 15 8 18 8 8 32 15 25 11 28 20 19 12 4 16 16 30 32 17 15 1 25 21 20 27 31 17 28 4 13 3 16 30 32 15 13 1 14 17 22 11 17 28 19/12/2017 151 4/12/2016 152 27/07/2016 153 29/06/2016 154 27/12/2016 155 29/10/2017 156 12/6/2017 157 14/05/2017 158 13/10/2016 159 4/12/2016 160 6/3/2016 161 19/12/2015 162 20/04/2016 163 6/3/2017 164 23/06/2015 165 3/5/2017 166 30/08/2017 167 26/08/2017 168 5/1/2018 169 17/01/2018 170 13/05/2016 171 17/03/2016 172 25/11/2016 173 12/8/2018 174 12/3/2015 175 15/06/2015 176 21/02/2016 177 19/06/2016 178 10/10/2016 179 27/05/2016 180 19/03/2015 181 8/8/2016 182 7/3/2018 183 28/04/2018 184 11/3/2018 185 8/8/2018 186 23/02/2016 187 10/7/2017 188 19/07/2018 189 7/8/2015 14/03/2018 191 28/03/2017 192 17/05/2018 193 14/05/2015 194 30/07/2015 195 19/09/2015 196 2/12/2016 197 24/07/2016 198 10/3/2018 199 14/02/2016 200 15 10 66 68 21 35 17 40 1 70 80 29 76 22 2 35 40 68 32 34 34 80 20 36 78 57 75 71 48 19 79 70 30 45 30 26 66 47 53 80 70 14 46 30 60 14 71 38 69 49 9 19 3 29 14 19 24 21 24 27 26 5 12 4 2 13 8 19 5 17 16 30 32 10 12 18 11 10 22 16 30 13 6 12 27 13 16 15 30 16 13 25 22 132 14 13 15 21 30 31 11/8/2018 201 29/08/2018 202 27/11/2016 203 12/7/2017 204 27/06/2018 205 22/01/2016 206 25/08/2016 207 9/7/2015 208 28/03/2016 209 10/7/2015 210 24/04/2016 211 18/10/2015 212 25/04/2018 213 24/12/2016 214 26/10/2017 215 28/02/2016 216 2/10/2017 217 3/1/2016 218 13/11/2016 219 15/09/2016 220 13/04/2018 221 13/10/2016 222 17/11/2015 223 1/9/2017 224 27/06/2018 225 22/03/2016|226 27/06/2017 227 1/8/2015 228 29/09/2015 229 21/02/2016|230 20/08/2018 231 16/09/2016 232 10/2/2017 233 12/10/2017 234 23/11/2016 235 13/08/2016 236 14/01/2017 237 10/2/2016 238 8/8/2018 239 31/03/2016 240 3/2/2018 241 27/03/2016|242 13/01/2016 243 6/8/2015 244 27/11/2016 245 23/05/2018 246 22/06/2016 247 27/12/2015248 29/04/2017 249 3/6/2018 250 28 49 75 78 43 27 64 21 66 45 48 20 41 51 5 5 40 79 15 42 17 38 79 74 46 78 45 72 18 29 66 36 26 32 62 12 38 29 36 76 28 60 8 25 62 51 27 69 51 17 31 28 3 1 3 18 21 22 11 29 13 30 25 20 12 1 13 4 10 122 19 13 2 13 18 22 2 31 17 3 11 16 12 1 14 4 32 16 25 7 16 13 3 1 29 18 23 12 12 4 15 29/05/2015 251 30/08/2016 252 29/10/2015 253 12/5/2017 254 25/03/2015 255 22/02/2016 256 3/4/2015 257 9/12/2017 258 20/12/2016 259 15/04/2017 260 31/01/2015 261 20/12/2017 262 29/01/2018 263 5/7/2015 264 12/4/2015 265 24/02/2018 266 27/06/2018 267 1/11/2016 268 28/12/2016 269 29/01/2018 270 9/5/2016 271 6/12/2017 272 7/12/2015 273 5/6/2016 274 11/8/2018 275 20/04/2015 276 11/11/2015 277 21/03/2015 278 13/08/2017 279 5/6/2018 280 28/04/2016 281 23/10/2016 282 31/10/2017 283 25/07/2017 284 8/7/2015 285 24/02/2015 286 28/07/2016 287 7/5/2017 288 13/06/2015 289 15/08/2016 290 26/08/2016 291 28/07/2017 292 30/07/2016 293 24/08/2018 294 1/9/2016 295 8/2/2015 296 25/06/2018 297 4/7/2015 298 1/5/2015 299 29/10/2017 300 14 14 39 79 40 51 61 15 10 67 79 19 35 27 30 8 70 56 13 61 47 30 18 34 32 19 62 44 27 61 5 43 34 35 13 74 70 42 51 45 70 77 74 47 10 16 48 72 26 49 7 9 18 19 2 13 22 22 29 21 28 24 22 5 28 13 19 19 5 12 18 31 17 24 30 17 7 25 14 2 21 5 3 23 23 15/01/2015 21/05/2018 26/12/2015 31/05/2016 18/03/2016 13/04/2018 11/2/2015 2/3/2018 21/01/2018 8/7/2017 11/12/2016 4/5/2016 1/8/2017 15/12/2017 22/12/2015 26/06/2015 20/03/2016 29/01/2016 6/3/2015 18/06/2016 18/09/2017 19/02/2016 31/12/2016 27/10/2017 3/6/2015 30/03/2016 23/03/2015 29/04/2017 25/03/2015 14/07/2017 4/12/2016 15/03/2018 5/6/2016 19/02/2018 23/09/2016 26/12/2016 15/08/2017 15/06/2016 30/07/2018 15/01/2015 7/10/2017 6/1/2017 25/09/2015 1/2/2018 18/04/2017 3/10/2016 17/09/2016 10/2/2017 1/3/2016 25/10/2016 190
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
