1. Create a PDF from only those pages that have some specific text:Use the PDF: meetingminutes.pdf (Links to an external site.) to write a program that will create a PDF from only those pages that have the word: student2. Brute-Force PDF Password Breaker: Say you have an encrypted PDF file: encrypted.pd (Links to an external site.)f (Links to an external site.) that you have forgotten the password to, but you remember it was a single English word.Write a program that will decrypt the PDF by trying every possible English word until it finds one that works.Download the text file dictionary.txt (Links to an external site.), this dictionary file contains over 44,000 English words with one word per line.Using the file-reading skills you learned, create a list of word strings by reading this file.Then loop over each word in this list, passing it to the decrypt() method.If this method returns the integer 0, the password was wrong and your program should continue to the next password.If decrypt() returns 1, then your program should break out of the loop and print the hacked password.You should try both the uppercase and lowercase form of each word. (Going through all 88,000 uppercase and lowercase words from the dictionary file may take a couple of minutes)

 Provide select statements to satisfy the following data requests:List all active male students assigned to Advisors 1 or 3 (Fred Stone or Jack Simpson).Provide a list of all students without a biography.What classes are in the English department?Create a list of all students and their advisors. Sort by the advisor’s name and then the student’s name. Include the student’s birth date, gender, and GPA.How many students were born in the 1980s?Write a query to show the average GPA by gender.Provide a list of all advisors and the number of active students assigned to each. Filter out any advisors with more than 1 student.Describe what you did for each step and paste in the actual SQL text used to perform each step.2014102620542320141019104324sql2.docx