Consider the StudentInfo table shown below, which stores stu…

Consider the StudentInfo table shown below, which stores student information. The Primary Key of this table is (StudentID). Attribute DataType Description StudentID Number ID of the university student LName String Last Name FName String First Name HomeZip Number 5 digit Zip code of Home address   Consider the StudentExternalEmail table shown below, which stores student’s non-university email information. The Primary Key of this table is a compound key (StudentID, Email).  Not all students have registered an external email address with the University. Attribute DataType Description StudentID Number ID of the university student Email String Email address   Write a SQL query to retrieve student information (id, LName, email) of students whose home zip code is ‘46556’

Suppose that Verizon Wireless has hired you as a consultant…

Suppose that Verizon Wireless has hired you as a consultant to determine what price it should set for calling services. Suppose that an individual’s inverse demand for wireless services in the greater Boston area is estimated to be P = 100 − 20Q and the marginal cost of providing wireless services to the area is $1 per minute. What is the optimal two-part price that you would suggest to Verizon?