Python

Have you created asynchronous functions when working with Python, for example in Django or with asyncio?

What benefit does async/await provide when making a database query?

Tell us about your recent project and the tasks you worked on.

Which cloud platforms have you worked with before?

Where is asynchronous programming used in Python and in what scenarios is it useful?

What approaches and techniques do you know for speeding up and increasing the efficiency of SQL queries?

What AWS services have you worked with?

Recently, you worked on a project with geospatial data. Tell us about it: what data did you use, how did you process it, where did you store it, and what was your contribution?

Have you worked with shell scripts in the past?

Table Customers: customer_id (INT), customer_name (VARCHAR), country (VARCHAR), signup_date (DATE) Table Orders: order_id (INT), customer_id (INT), order_date (DATE), order_amount (DECIMAL), status (VARCHAR) Task: Write a query to find the total order amount and the total count of orders for each customer from the 'USA' who has spent a total of more than 500 on 'Completed' orders. Sort the results by total order amount in descending order. Expected Output: customer_name (VARCHAR), total_spent (DECIMAL), total_orders (INT)

Briefly introduce yourself and tell about yourself.