1. Using SQL, answer the following question referring to the table below
   1. How many twins are there? (Just having the same birthday does not make you twins.)
2. 2. Name the twins.

CREATE TABLE IF NOT EXISTS students (

student_id INT NOT NULL AUTO_INCREMENT,

first_name VARCHAR(16),

last_name VARCHAR(24),

birthday DATE,

street_address VARCHAR(128),

city VARCHAR(32),

PRIMARY KEY (student_id));

INSERT INTO students

(first_name, last_name, birthday, street_address, city) VALUES

('John','Jones','2000-12-17','250 Pines Blvd.','Pembroke Pines'),

('Mark','Bacon','2000-04-12','1270 Walnut St.','Prarie Bluff'),

('Bill','Carlson','1999-07-06','250 Pines Blvd.','Pembroke Pines'),

('Jean','Carlson','1999-07-06','250 Pines Blvd.','Pembroke Pines'),

('Leonard','Cook','2000-09-14','8046 Maple St.','Highland Park'),

('William','Markham','1999-07-06','1600 Sylvan Ln.','Lake Forest'),

('Sam','Cook','1998-10-13','8046 Maple St.','Highland Park'),

('Fred','Williams','1999-07-08','722 Oack Knoll','Arlington'),

('Sally','Fillmore','2000-03-25','1215 Carrington St.','Decatur'),

('Mary','Jones','1999-11-13','1940 Grant St.','Denver'),

('Phyllis','Jones','1999-11-13','1940 Grant St.','Denver');

IN C LANGUAGE

You decide you want to build a skate park in your backyard, so you need to buy a lot of concrete. The good news is, you can get a discount when you buy in bulk. The price of concrete for different grades of concrete per cubic yard is as follows:

• when grade is either "low" or "cheap"
  • $100 (per cubic yard) for less than 200 cubic yards
  • $95 for between 200 and 400 (including 200 and 400) cubic yards
  • $90 for more than 400 cubic yards
• when grade is either "high" or "expensive"
  • $150 for less than 250 cubic yards
  • $135 for 250 or more cubic yards

Write a program that calculates the price of an order of concrete when given the grade and quantity.

Notes

• You can assume valid input.
• The grader is checking if your output ends with the integer dollar amount (no cents or punctuation).

Examples

What grade of concrete (low/cheap, high/expensive)?
low
How many cubic yards of concrete?
75
The cost is $7500

The answer to the example above is calculated from 75 * $100 (low grade, less than 200 cubic yards) = $7500

What grade of concrete (low/cheap, high/expensive)?
cheap
How many cubic yards of concrete?
75
The cost is $7500

What grade of concrete (low/cheap, high/expensive)?
high
How many cubic yards of concrete?
75
The cost is $11250

What grade of concrete (low/cheap, high/expensive)?
expensive
How many cubic yards of concrete?
75
The cost is $11250

[PLEASE ANSWER IN EXCEL TEMPLATE BELOW (A/B ON SEPARATE PAGES) AND SHOW FORMULAS/SOLVER INFO]

La Quinta Inn is staffing its receptionists in its biggest hotel in San Antonio. Receptionists work 6-hour shifts at the hotel lobby. There are two types of receptionists: those who speak English as a first language and those who are fully bilingual (English and Spanish). The requirements for the number of receptionists depend on the customer arrivals during various hours. The Inn believes that the need for receptionists between the hours of 7 A.M. and 10 P.M. are as follows:

Receptionists begin work either at 7 A.M., 10 A.M., 1 P.M., or 4 P.M. At least half of the receptionists needed in any time period should speak English as the first language. Further, at least one-quarter of the receptionists needed in any time period should be fully bilingual.

A) How many and what type of receptionists should be hired for each shift to meet the language and staffing requirements, so that the total number of receptionists is minimized?

B) What is the optimal hiring plan from a cost perspective if English-speaking receptionists are paid $30 per hour and bilingual receptionists are paid $35 per hour?

Sailplanes use updrafts to stay aloft for hours at a time. Near one particular airfield, a stone quarry (with very dark rocks) surrounded by a wooden area provides a particularly regular source for updrafts on hot days. With your knowledge of heat transfer, explain the processes that create the updraft

What happens to the light [energy] after it enters an eye and hits the rods and cones? I presume the energy becomes electrical, and it must be near 100% perfect, else our eyes would heat up? Or am I missing something?

The motivation of this question is solar panel technology.

Briefly discuss the main difference between the valence bond and molecular orbital treatments of electronic states in molecules. Which is a better representation of molecules with all bond lengths at their equilibrium separation? And which is better when one or more bond lengths are stretched near their dissociation limit? Explain.

For each of the following, would a score of X = 85 be considered a central score (near the middle of the distribution) or an extreme score (far out in the tail of the distribution)? µ =75 and σ = 15 µ =80 and σ = 2 µ =90 and σ = 20 µ =93 and σ = 3

What are the main characteristics of born global firms? Evaluate the drivers of market globalization that have allowed born global firms such as Instagram to internationalize at, or near, their founding. What advantages do you think a young company can gain by entering international markets soon after their founding?

Experiences with a school-age child whose family is at or near the poverty level. How did poverty impact their life? Include examples of strengths within the child and family, or relationships and resources available to them outside of the family that may have helped them overcome some of the obstacles to their success.