Tell me more about your course project: what kind of bot it is, what functionality, what features were included in the model?
Intern
305
Data Analyst
287
0
Have you worked with window functions? Which ones do you know?
Intern
204
How does the WHERE operator differ from the HAVING operator?
Intern
199
Task 2. JOIN tables Requirement: Get a list of all clients (alphabetically), regardless of whether they have loans or not, and add a field to each client called total_loan_amount – the total sum of all their loans. If a client has no loans, display 0. Output – three columns: client_id, client_name, total_loan_amount.
Intern
116
Task 1. Counting clients by status Requirement: Write a query that outputs the number of clients in each status (active, inactive, blocked, etc.). The result should contain two columns: status and cnt.
Intern
113
Tell about yourself: what do you do, what would you like to do, what are your development plans?
Intern
103