Data Analyst Quiz
31. What does the SUM function in SQL do? Counts the number of records Returns the total sum of a numeric column Returns the highest value in a column Sorts the records Submit 32. In a box plot, what does the box represent? The mean value of the dataset The interquartile range (IQR) The maximum value The outliers Submit 33. What is the main use of the GROUP BY clause in SQL? To filter rows To join tables To aggregate data based on columns To sort records Submit 34. Which of the following is a Python library used for machine learning? NumPy Pandas Scikit-learn Seaborn Submit 35. What does the WHERE clause in SQL do? Joins two tables Filters records based on a condition Groups data Aggregates data Submit 36. In Python, what does the DataFrame object represent in the Pandas library? A 2D labeled data structure A 3D data array A list of data A tool for machine learning Submit 37. What is the purpose of the H