Python pandas exersize Dataset url = "https://raw.githubusercontent.com/justmarkham/DAT8/master/data/chipotle.tsv 1. Import the necessary libraries 2. Import the dataset from ur! 3. Assign it to a variable called var. 4. How many products cost more than $10.00? 5. What is the price of each item?

Code a chain of MongoDB methods that   retrieves documents from MondoDB collection named WEB322the only documents that are selected are the ones with value 211 in the semester field the only fields of the selected documents that are retrieved are firstName and lastNamemake sure the _id field is NOT retrievedsort the selected documents by lastName in ascending sequencestore the result to an array named resultassume the connection between the program and database had already been established and the name of the database object is db

You have a table that contains the following fields: Last Name, First Name, Street, City, State, and Postal Code. There are 50,000 records in the table. What indexes would you create for the table?   You have a table that contains the following fields: Book ISBN Number, Book Title, Author Last Name, Author First Name, Publication Year, and Publisher Name. There are 75,000 records in the table. What indexes would you create for the table?

SQL Use the IN operator to list the item ID and description of each item in category FSH or BRD.