A scatter plot is a type of graph used in Exploratory Data Analysis (EDA) to visualize the relationship between two continuous variables. It displays the data points as points on a coordinate grid, with the x-axis representing one variable and the y-axis representing the other.
The primary purpose of a scatter plot is to:
Show the strength and direction of the relationship between the two variables
Identify patterns, correlations, or outliers in the data
Help identify potential relationships that may not be immediately apparent from looking at individual variables
The correct answer is: Dept_id should not be used in group by clause (although this is not the case in the given query, as it uses dept_name)
The error in the statement is that the ID column is not included in the GROUP BY clause. When using an aggregate function like AVG, all non-aggregated columns in the SELECT clause must be included in the GROUP BY clause.
The minimum number of colors required for proper vertex coloring of graph is called chromatic number whereas the minimum number of colors required for proper edge coloring of graph is called chromatic index of a graph.