Blog

What does “ETL” in the ETL process refer to?

An online transaction processing system (OLTP) is an example of a data warehouse.

22. How many colleges have received applications? (4 points)  23. Report the name and GPA of students with a GPA greater than 3.5. List the results by GPA from highest to lowest. (4 points)  24. Please help LSU find the names of admitted students. (4 points)  25. For each college, report the college’s name and number of applications (rename as NumOfApp) from students with a GPA of 3.0 or above. (4 points)   26. Report the majors applied to by all students who attended a high school with fewer than 1,000 students. Do not use a nested query. Eliminate duplicate results. (4 points)  

Provide precise and complete SQL code to answer the questions below. You should report values in the order in which they are listed in the question and with no additional values beyond what is requested. The following questions (Q22-Q26) refer to the schema depicted in the Appendix below that contains 2 tables (i.e., student and application) having the columns named in bold and values shown below the column names.Assume that VARCHAR data type is used for all attributes except ‘GPA’ and ‘sizeHS’ which use the DECIMAL data type.  student       sID sName GPA sizeHS 123 Amy 3.90 1000 234 Bob 3.60 1500 345 Craig 3.50 500 456 Doris 3.90 1000 543 Craig 3.40 2000 567 Edward 2.90 2000 654 Amy 3.90 1000 678 Fay 3.80 200 765 Jay 2.90 1500 789 Gary 3.40 800 876 Irene 3.90 400 987 Helen 3.70 800 application         aID cName major admitted sID 1 Emory ISDS Y 123 2 LSU CS Y 123 3 LSU EE N 123 4 Tulane CS Y 123 5 UT Austin EE Y 123 6 Tulane biology N 234 7 Emory bioengineering Y 345 8 UT Austin bioengineering N 345 9 UT Austin CS Y 345 10 UT Austin EE N 345 11 Emory CS N 543 12 LSU history Y 678 13 LSU history Y 765 14 UT Austin history N 765 15 UT Austin psychology Y 765 16 Emory biology Y 876 17 Emory marine biology N 876 18 LSU CS N 876 19 LSU CS Y 987 20 Tulane CS Y 987

A SQL query can perform calculations as specified in the SELECT clause of the query.

This question is based on the following tables. Based on primary key and foreign key rules, could I Insert (SL63, ‘John’, ‘Smith’, ‘CFO’, ‘M’, 01-Apr-00, 500000, NULL) into Staff table?           

Please list the three sub-languages of SQL. Spell out your answers, do not only provide acronyms.

In SQL, aggregation functions can return more than one row of output without a GROUP BY clause.

What is the SQL command that imposes a constraint that filters rows? 

Destiny has a persistent, irrational fear of open water, which makes her avoid beaches, boats, and lakes. What condition does this describe?