Search results
Jan 6, 2022 · Contests: The contest_id is the id of the contest, hacker_id is the id of the hacker who created the contest, and name is the name of the hacker. Colleges: The college_id is the id of the...
Jul 20, 2020 · Contests: The contest_id is the id of the contest, hacker_id is the id of the hacker who created the contest, and name is the name of the hacker. Colleges: The college_id is the id of the...
Nov 8, 2022 · Find and win competitions with insider tips. From £23,800 in cash to five-star holidays, MoneySavers have won the lot. It's all about 'comping', a potentially profitable hobby. This guide covers sourcing the right free competitions, using web gadgets to form-fill at speed and much more.
- Print Prime Numbers
- New Companies
- Weather Observation Station
- Binary Tree Nodes
- Question: Tenured Employees
- Challenge Question: 15 Days of Learning SQL
- Challenge Question: Interviews
Solve Problem Write a query to print all prime numbers less than or equal to 1000. Print your result on a single line, and use the ampersand (&) character as your separator (instead of a space). For example, the output for all prime numbers <= 10 would be: 2&3&5&7
Solve Problem Amber’s conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy: Founder → Lead Manager → Senior Manager → Manager → Employee Given the table schemas below, write a query to print the company_code, founder name, total number of lead managers, total number of senior managers, total number...
Solve Problem Consider P1(a,b) and P2(c,d) to be two points on a 2D plane. 1. ahappens to equal the minimum value in Northern Latitude (LAT_N in STATION). 2. bhappens to equal the minimum value in Western Longitude (LONG_W in STATION). 3. chappens to equal the maximum value in Northern Latitude (LAT_N in STATION). 4. dhappens to equal the maximum v...
Solve Problem You are given a table, BST, containing two columns: N and P, where N represents the value of a node in Binary Tree, and P is the parent of N. Write a query to find the node type of Binary Tree ordered by the value of the node. Output one of the following for each node: 1. Root: If node is root node. 2. Leaf: If node is leaf node. 3. I...
Concepts Covered: SQL (Basic), JOIN, ORDER BY There are two data tables with employee information: EMPLOYEE and EMPLOYEE_UIN. Query the tables to generate a list of all employees who have been employed fewer than three years in order of NAME, then of ID, both ascending. The result should include the UIN followed by the NAME. While the secondary sor...
Solve Problem Difficult Level:Hard Julia conducted a 15 days of learning SQL contest. The start date of the contest was March 01, 2016 and the end date was March 15, 2016. Write a query to print the total number of unique hackers who made at least 1 submission each day (starting on the first day of the contest), and find the hacker_id and name of t...
Solve Problem Difficulty Level: Hard Samantha interviews many candidates from different colleges using coding challenges and contests. Write a query to print the contest_id, hacker_id, name, and the sums of total_submissions, total_accepted_submissions, total_views, and total_unique_views for each contest sorted by contest_id. Exclude the contest f...
Aug 20, 2023 · Write a query to print the contest_id, hacker_id, name, and the sums of total_submissions, total_accepted_submissions, total_views, and total_unique_views for each contest sorted by...
Samantha interviews many candidates from different colleges using coding challenges and contests. Write a query to print the contest_id, hacker_id, name, and the sums of total_submissions, total_accepted_submissions, total_views, and total_unique_views for each contest sorted by contest_id.
People also ask
Can a contest be used to screen candidates at more than one college?
Which tables contain contest data?
What data should be stored in a contest query?
What is the connection between c ontests and contests table?
Mar 31, 2024 · Contests: The contest_id is the id of the contest, hacker_id is the id of the hacker who created the contest, and name is the name of the hacker. Colleges: The college_id is the id of the college, and contest_id is the id of the contest that Samantha used to screen the candidates.
