ylyhlh

# http://grouplens.org/datasets/movielens/

DROP TABLE IF EXISTS movies.ratings;
DROP TABLE IF EXISTS movies.users;
DROP TABLE IF EXISTS movies.movies;

CREATE TABLE IF NOT EXISTS movies.users (
    userID INT PRIMARY KEY,
    age INT,
    gender TEXT,

ylyhlh

#include <iostream>
#include "MoneyChanger.h"

//Testing conceptional constance with 'mutable' keyword
class testClass {
    /* make it mutable then callable by const fucntion.
     * It's better to make memberfunction called by this class
     * be const function. In that way you do not need mutable
     * funciton here. But some time you cannot modify it,
     * for example you are using prebuild library  */

ylyhlh

//---------
//Question:
//---------
/*Assume the US dollar is available in denominations of
 *$100, $50, $20, $10, $5, $1, $0.25, $0.10, $0.05 and 
 *$0.01.  Write a function to return the number of 
 *different ways to exactly represent an arbitrary value
 *less than $1,000.00 using any number or 
 *combination of these denominations.
 */

ylyhlh

###################################################
#Here are some codes I wrote in python for learning
###################################################
# A prefix Calculator
import prefixCalclulator
prefixCalclulator.test()

ylyhlh

These quizs are very interesting and helpful. It's for query and data manipulation. Two small databases used to demonstrate basic query syntax, various subquery syntax and some DML.