Page 179 - Artificial Intellegence_v2.0_Class_11
P. 179
RIGHT JOIN table2
ON table1.matching_column = table2.matching_column;
Full Outer Join
Combines the result of both LEFT JOIN and RIGHT JOIN. It returns all records which match Left Right
in either left or right table. Table Table
Syntax: SELECT table1.column1, table1.column2, table2.column1, ....
FROM table1
FULL JOIN table2
ON table1.matching_column = table2.matching_column;
Reboot
1. Identify the type of join and the set operation from the diagram given below:
table 1 table 2
2. Identify the relational and set operation from the diagram given below:
A B
Simple Statistical Concepts
Statistics is a set of tools that can be used to obtain answers to important questions about data. It is generally
considered a prerequisite in the field of machine learning. We need statistics to help turn observations into information
and answer questions about observation samples.
“Central tendency” is expressed as a summary of a data set in a single value, representing the entire distribution of
a data domain (or data set). Central tendency does not analyze the individual values in the data set but provides a
complete summary of the entire data.
Maths for AI 177

