Questions and Answers
Problems and Solutions
Quotes help make search much faster. Example: "Practice Makes Perfect"
Monday, July 18, 2016
SQL: Table Transformation Lesson 5 Sample Solution
Instruction:
Find the id of the flights whose distance is below average for their carrier.
Sample Solution:
SELECT id
FROM flights AS f
WHERE distance < (
SELECT AVG(distance)
FROM flights
WHERE carrier = f.carrier);
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
This is an example of
scrolling text
using Javascript.
Popular Posts
Codecademy Sample Solution: Final Push
$VERBOSE = nil # We'll explain this at the end of the lesson. require 'prime' # This is a module. We'll cover these s...
Codeschool Sample Solution Removing the clicked button
$(document).ready(function(){ $("button").on("click", function(){ var message = $("<span>Call 1-555-...
Codecademy - Animate Your Name: Arrays
//Sample solution to main.js var red = [0, 100, 63]; var orange = [40, 100, 60]; var green = [75, 100, 40]; var blue = [196, 77, 55]; ...
LearnStreet Sample Solution Sudoku Solver Project Method 1
// Sudoku Solver Project function isPossibleRow(sudoku, row, number) { // This isPossibleRow() function returns true if the 'numbe...
SQL: Table Transformation Lesson 11 Sample Solution
Instructions: Select the items in the category column that are both in the newly acquired new_products table and the legacy_products table....
Codefights isMAC48Address(inputString)
//sample solution function isMAC48Address(inputString) { if(inputString.length!=17){ return false; } var regex = /^([0-9A...
Codecademy Sample Solution: Arithmetic
<!DOCTYPE html> <html> <head> <title></title> </head> <body> <!-- Include y...
Make a Website: HTML Wrap with a div 5/9
<!-- Sample solution to index.html --> <!DOCTYPE html> <html> <body> <div class="nav"> ...
Codecademy Learn Phaser: Keyboard Events 10/12
//Sample Solution const gameState = {} function preload() { this.load.image('codey', 'https://s3.amazonaws.com/codecademy-...
Math Problems: Collatz Function
Problem: The Collatz function is defined as f(n) = 3n+1 for odd values of n and f(n) = n/2 for even values of n. What is the smallest poss...
No comments:
Post a Comment