This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 1. Find the names of all students who are friends with someone named Gabriel. | |
SELECT H1.name | |
FROM Highschooler H1 | |
INNER JOIN Friend ON H1.ID = Friend.ID1 | |
INNER JOIN Highschooler H2 ON H2.ID = Friend.ID2 | |
WHERE H2.name = "Gabriel"; | |
-- 2. For every student who likes someone 2 or more grades younger than themselves, return that student's name and grade, and the name and grade of the student they like. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
+----------------------------------------------+---------------------+ | |
| Company Name | Nbr of job postings | | |
+----------------------------------------------+---------------------+ | |
| CivilMaps | 4 | | |
| Booz Allen Hamilton | 1 | | |
| Delphi | 15 | | |
| ISP Optics Corporation | 3 | | |
| Stride Search | 7 | | |
| Rand McNally | 1 | | |
| Zemax | 1 | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import java.io.*; | |
import java.util.*; | |
/** The class encapsulates an implementation of the Apriori algorithm | |
* to compute frequent itemsets. | |
* | |
* Datasets contains integers (>=0) separated by spaces, one transaction by line, e.g. | |
* 1 2 3 | |
* 0 9 | |
* 1 9 |