What is SQL mostly used for in a Data Analyst/Scientist role?

Web: https://www.reddit.com/r/datascience/comments/uq0q4t/what_is_sql_mostly_used_for_in_a_data/

I (w/ 2 YOE) am curious because as I'm practicing problems on Leetcode for interview prep, a lot of the questions prompted are extremely mathematical (which I've never seen) and are way beyond the simple aggregations/manipulations done to merge/transform tables and whatnot.

So are these types of prompts often situations you guys would use SQL in? I've pasted an example problem below:

"Tic-tac-toe is played by two players A and B on a 3 x 3 grid. The rules of …

analyst data data analyst datascience role sql