SUBJECT/TOPIC: MySQL Database Management System (xampp)PLEASE ANSWER THIS WITH COMPLETE EXPLANATION AND SOLUTION. ASSESSMENT TASK MySQL Database Management System (xampp) 1. You are creating a database named NewDB. The database uses the server'sdefault character. What SQL statement should you use to create the database?2. You are creating a table in a MYSQL database from previous number. The table isnamed Bikes and includes two columns: BikelD and BikeName. The BikelDcolumn must uniquely identify each row in the table, and values must beautomatically assigned to each row. The BikeName column must include adescriptive name for each model of bike. The names vary in length but shouldnever exceed 40 characters. What SQL statement should you use to create thetable?3. Write a SQL statement to insert the given data into the table countries against eachcolumn.IdCountry1 Malaysia2Thailand3Mongolia4Georgia5Turkmenistan956 Philippines7IsraelHere in the following is the structure of the table "countries".| Field1 Туре| Null | Key | Default | Extra || COUNTRY_IDCOUNTRY_NAME | varchar(40)| varchar(2)| VES IYES |NULLNULL 1. You are creating a SELECT statement that retrieves data from the CDstable. Your query results should include values from the CDName, InStock,OnOrder, and Reserved columns. In addition, the results should include allrows in the table. What SELECT statement should you create?2. You want to modify the SELECT staternent that you created in AssessmentNo. 1 so that the result set includes an additional column. The columnshould add the values of the InStock and OnOrder columns and thensubtract the value in the Reserved column. You want to assign the Totalalias to the new column. What SELECT statement should you create?3. Your next step is to modify the SELECT statement that you created inAssessment No. 2. You plan to limit the rows returned to those rows that121have a Department value of Classical and an InStock value less than 20.What SELECT statement should you create?4. You now want to create a SELECT statement that summarizes data in theCDs table. The result set should include data that is grouped together bythe Department column and then by the Category column. The summaryinformation should include the number of rows for each category, as well astotals for all categories in each department. In addition, the summarycolumn in the result set should be assigned the alias Total, and all groupedcolumns should be sorted in ascending order. What SELECT statementshould you create?5. You now want to modify the SELECT statement that you created inAssessment No. 4 to limit the rows returned to those with a Total value lessthan 3. What SELECT statement should you create?6. You are creating a SELECT statement that retrieves data from the CDstable. Your query results should include values from the CDName column.The values should be sorted in descending order. What SELECT statementshould you create?

Kindly Note: As per our company guidelines we are supposed to answer only first 3 sub-parts. Kindly…

1. You are creating a database named NewDB. The database uses the server's default character. What SQL statement should you use to create the database? 2. You are creating a table in a MYSQL database from previous number. The table is named Bikes and includes two columns: BikelD and BikeName. The BikelD column must uniquely identify each row in the table, and values must be automatically assigned to each row. The BikeName column must include a descriptive name for each model of bike. The names vary in length but should never exceed 40 characters. What SQL statement should you use to create the table? 3. Write a SQL statement to insert the given data into the table countries against each column. Id Country Malaysia 1 2 Thailand 3 Mongolia Georgia Turkmenistan 4 5 6 Philippines 7 Israel Here in the following is the structure of the table "countries". | Field I Type | Null | Key | Default | Extra | | COUNTRY_ID | COUNTRY_NAME | varchar(40) | VES I | VES I varchar(2) | MULL NULL