🐍 Python Programs

📌 Average Function

import math
import os
import random
import re
import sys

def avg(*nums):
    return sum(nums)/len(nums)

if __name__ == '__main__':

📌 Reverse Words Order and Swap Cases

#!/bin/python

def reverse_words_order_and_swap_cases(sentence):
    word_list = sentence.split()
    reversed_list = word_list[::-1]
    reversed_sentence = " ".join(reversed_list)
    return reversed_sentence.swapcase()

if __name__ == '__main__':
    fptr = open(os.environ['OUTPUT_PATH'], 'w')
    sentence = input()
    result = reverse_words_order_and_swap_cases(sentence)
    fptr.write(result + '\n')
    fptr.close()

📌 Shape Classes with Area Method

class Rectangle:
    def __init__(self, breadth, length):
        self.breadth = breadth
        self.length = length
    
    def area(self):
        return self.breadth * self.length

class Circle:
    def __init__(self, radius):
        self.radius = radius
    
    def area(self):
        return math.pi * (self.radius ** 2)

📌 Gaming Laptop Battery Life

def getBattery(events):
    c = 50
    for i in events:
        if i < 0:
            c += i
        else:
            c += i
            if c > 100:
                c = 100
        print(c)
    return c

📌 String Anagram

from collections import Counter

def stringAnagram(dictionary, query):
    dict_sorted = ["".join(sorted(word)) for word in dictionary]
    query_sorted = ["".join(sorted(word)) for word in query]
    result = []
    count = Counter(dict_sorted)
    
    for word in query_sorted:
        result.append(count.get(word, 0))
    
    return result

---

☕ Java Programs

📌 The Adder Class

class Adder extends Calculator {
    int add(int a, int b) {
        return a + b;
    }
}

---

🛢️ SQL Queries

📌 Student Advisor

SELECT std.roll_number, std.name 
FROM student_information std, faculty_information fi 
WHERE std.advisor = fi.employee_id 
AND (fi.gender = 'M' AND fi.salary > 15000 OR fi.gender = 'F' AND fi.salary > 20000);

📌 Products Without Sales

SELECT sku, product_name 
FROM PRODUCT P 
LEFT JOIN INVOICE_ITEM Ii ON Ii.product_id = P.id 
WHERE invoice_id IS NULL 
ORDER BY SKU;

📌 Customer Spending

SELECT b.customer_name, CAST(a.total_price AS DECIMAL(10,6)) amount 
FROM customer b, invoice a 
WHERE a.customer_id = b.id 
AND a.total_price <= (SELECT (0.25 * AVG(a.total_price)) FROM invoice a) 
ORDER BY amount DESC;

SELECT customer_name, TO_CHAR(total_price, 'fm9999999.900000') 
FROM customer c, Invoice i 
WHERE c.id = i.customer_id 
AND total_price < (SELECT (0.25) * SUM(total_price) / COUNT(id) FROM Invoice);