EXERCISE: BABY NAMES (SQL/JDBC) INSTRUCTIONS Download and extract the database files: babynames-derby.zip . Follow the instructions from the textbook and/or your instructor to connect to the database. (Username:user, Password:password). This database contains information about baby names in the United States in a table called babynames. (Source: https://www.kaggle.com/kaggle/us-baby-names Ex) Schema: USER User : user Password: password babynames Table Schema: COLUMN_NAME | TYPE_NAME ID | INTEGER NAME VARCHAR DATE_YEAR | INTEGER GENDER | CHAR US STATE | CHAR NUM BABIES | INTEGER Note: Many databases have a "LIMIT n" clause that allows selection of the first n items. Derby does not have this feature, but it can be simulated by adding a "FETCH FIRST n ROWS ONLY" clause.PART 1 WTl'lIL'.' a query to answer the following questions [include both query and result in response where applicable]: 1. 1|What was the most common boy's name in Maryland in 1991 . In which year were the most baby boy's named "Christopher" born in any state? . In which year were the most baby girls named "Rosemary" born in any state? . In 2014. which state had the fewest boys named "){ayier" 2 3 4. In 200G.which baby names were used more than than EDD times in Maryland 5 a. In 199% which state had the most girls named \"Hannah" ? .Write a query to add the following row: o id110iJDDDCiID o name:'Joseph' o date_year: 2316 o gender: 'M' o us_state: 'PA' o num_babies: '4Tr5' 8. Write a query to delete the row you just added. '5'. {Bonus} 1What was the most common boy's name across the United States in 19?1 o Hint: use "SUM" and "GROUP BY" PART 2 Repeat the preyious exercises using a Jaya program with JDBC calls. 6 SUBMISSION INSTRUCTIONS Add the following to your GitHub repository: - A ".txt" or ".sqi" le containing all the database queries from Part 1. - A screenshot ofyou running the query for #6 {Part 1} 0 Yes - ordinarily you don't add binary files like images to a git repository. but it's GK here. - The Java project from Part 2