subject

Presidents Imagine a relation Presidents(firstName, lastName, beginTerm, endTerm) that gives information about US Presidents. Attribute firstName is a string with the first name, and in some cases, one or more middle initials. Attribute lastName is a string with the last name of the president. For example, the previous president has firstName = 'George W.' and his father has firstName = 'George H. W.'; both have lastName = 'Bush'. The last two attributes, beginTerm and endTerm, are the years the president entered and left office, respectively. One subtlety is that Grover Cleveland served two noncontiguous terms. He appears in two tuples, one with the beginning and ending years of his first term and the other for the second term. Write the following queries: Which president was in office in 1900? Give his first and last name. Which presidents served in only one year? Give their first and last names. How many presidents served terms of more than four years (i. e., the difference between the beginning and ending years of their terms is greater than 4)? You may know that there are two pairs of presidents that were father and son. But there are a number of other pairs of presidents that shared a last name. Find all the last names belonging to two or more presidents. Do not repeat a last name, and remember that the same person serving two different terms (e. g., Grover Cleveland) does not constitute a case of two presidents with the same last name. What is the average length of a president's term for all those terms that began after 1900? Which president (first and last names) served between Grover Cleveland's two terms?

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 08:00
Apex q: what does a low employment rate indicate? a. not many people are earning high salaries b. not many people are going to college c. not many people are renting their homes d. not many people have jobs
Answers: 2
question
Computers and Technology, 22.06.2019 08:10
Alook-up table used to convert pixel values to output values on a monitor. essentially, all pixels with a value of 190 or above are shown as white (i.e. 255), and all values with a value of 63 or less are shown as black (i.e. 0). in between the pixels are scaled so that a pixel with a value p is converted to a pixel of value 2/127 −+3969). if a pixel has a value of 170 originally, what value will be used to display the pixel on the monitor? if a value of 110 is used to display the pixel on the monitor, what was the original value of the pixel?
Answers: 1
question
Computers and Technology, 23.06.2019 01:10
Are special combinations of keys that tell a computer to perform a command. keypads multi-keys combinations shortcuts
Answers: 1
question
Computers and Technology, 23.06.2019 21:40
Simon says is a memory game where "simon" outputs a sequence of 10 characters (r, g, b, y) and the user must repeat the sequence. create a for loop that compares the two strings. for each match, add one point to user_score. upon a mismatch, end the game. sample output with inputs: 'rrgbryybgy' 'rrgbbrybgy'
Answers: 3
You know the right answer?
Presidents Imagine a relation Presidents(firstName, lastName, beginTerm, endTerm) that gives inform...
Questions
question
Mathematics, 01.04.2020 19:43
question
Mathematics, 01.04.2020 19:43