Probability | Lecture 1 | Fundamental of Statistic

Experiment: Experiment is a process of observation. Here, we will use E to denote it.

Sample Space: The set of all possible outcome of the experiment. We will use S to denote it.

Experiment 1:

E1: Toss a true coin three times and observe the sequence of heads and tails.
Total sample space {2}^{3} = 8

Continue reading “Probability | Lecture 1 | Fundamental of Statistic”

Advertisements

SQL Practice | Day 4

SCHEMA:

REGIONS(REGION_ID, REGION_NAME)
COUNTRIES(COUNTRY_ID, COUNTRY_NAME, REGION_ID)
LOCATIONS(LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY,STATE_PROVINCE, COUNTRY_ID)
DEPARTMENTS(DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,LOCATION_ID)
EMPLOYEES(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
JOB_HISTORY(EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
JOBS(JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)

Question A: For each employee print last name, salary, and job title. Continue reading “SQL Practice | Day 4”