import sqlite3 from contextlib import closing conn = sqlite3.connect("books. sqlite") conn. row_factory = sqlite3.Row with closing(conn. cursor()) as c: query = '''SELECT * FROM Book WHERE pages > ?''' c. execute(query, (100,)) books = c. fetchall() for book in books: print(book["name"], "|", book["author"], "|", book["pages"]) name = "The Case of the Killer Kangaroo" author = "Jane Doe" pages = 408 genreID = 1 with closing(conn. cursor()) as c: query = '''INSERT INTO Book (name, author, pages, genreID) VALUES (?, ?, ?, ?)''' c. execute(query, (name, author, pages, genreID)) connmit() print(name, "inserted.") author = "Katie Kanga" with closing(conn. cursor()) as c: query = '''UPDATE Book SET author = ? WHERE name = ?''' c. execute(query, (author, name)) connmit() print(name, "updated.")

Matlab question: use switch and anythe lottery game matches three different integer numbers between 1 and 10. winning depends on how many matching numbers are provided by a player. the player provides three different integers between 1 and 10.if there is a match of all 3 numbers, the winning $ 1000.if there is a match with 2 numbers, the winning $ 10.if there is a match of all with 1 numbers, the winning $ 1.with no match, the winning is $0.write a function lottery3 that checks three numbers provided by a player and determine the winning amount. if the user mistakenly enters same number twice/thrice and if that number matches one of the winning numbers, the code should count that number only once and display correct result. the player doesn’t have to guess the order of numbers.the input to the function lottery3 can have up to two input arguments. the first input argument is a row array numbers with 3 numbers. if the second argument input testcode is present, and is a row vector of 3 values, the function lottery3 uses the code in testcode as the three winning numbers (the test must be three different integer numbers between 1 and 10), else three different numbers will be automatically generated by testcode.the ouput should return the variable winnings and the three winning numbers in the row array winnumbers.hint: make use of the internal function any.restriction: the function must use switch-case statements to determine the winning.example #1: winning = lottery3( [1,2,1],[1,2,3])produceswinning =10example #2: [winning,winnumbers] = lottery3( [1,2,3])produceswinning =3winnumbers =8 5 3

In a compound condition, both conditions on either side of the logical operator and must be true for the overall condition to be true. a: true b: false

Which of the following would not be considered a pc? a. mainframe b. desktop c. tablet pc d. laptop