Not Boring Movies solution and explanation

from sqlalchemy import create_engine, Table, Column, Integer, String, Float, MetaData
from sqlalchemy.orm import sessionmaker

# Create an in-memory SQLite database
engine = create_engine('sqlite:///:memory:', echo=False)
metadata = MetaData(bind=engine)

# Define the Cinema table
cinema_table = Table('Cinema', metadata,
    Column('id', Integer, primary_key=True),
    Column('movie', String),
    Column('description', String),
    Column('rating', Float))

# Create the table
metadata.create_all()

# Insert example data
engine.execute(cinema_table.insert(), [
    {'id': 1, 'movie': 'War', 'description': 'great 3D', 'rating': 8.9},
    {'id': 2, 'movie': 'Science', 'description': 'fiction', 'rating': 8.5},
    {'id': 3, 'movie': 'irish', 'description': 'boring', 'rating': 6.2},
    {'id': 4, 'movie': 'Ice song', 'description': 'Fantasy', 'rating': 8.6},
    {'id': 5, 'movie': 'House card', 'description': 'Interesting', 'rating': 9.1}
])

# Query for not boring movies with odd IDs
Session = sessionmaker(bind=engine)
session = Session()

query = session.query(cinema_table).filter(
    sql.text('id % 2 != 0 AND description != "boring"')
).order_by(sql.text('rating DESC'))

results = query.all()
for row in results:
    print(f'id: {row.id}, movie: {row.movie}, description: {row.description}, rating: {row.rating}')

using System;
using System.Linq;
using System.Collections.Generic;

public class Movie {
    public int Id { get; set; }
    public string Name { get; set; }
    public string Description { get; set; }
    public float Rating { get; set; }
}

public class Program {
    public static void Main() {
        var movies = new List<Movie> {
            new Movie { Id = 1, Name = "War", Description = "great 3D", Rating = 8.9f },
            new Movie { Id = 2, Name = "Science", Description = "fiction", Rating = 8.5f },
            new Movie { Id = 3, Name = "irish", Description = "boring", Rating = 6.2f },
            new Movie { Id = 4, Name = "Ice song", Description = "Fantasy", Rating = 8.6f },
            new Movie { Id = 5, Name = "House card", Description = "Interesting", Rating = 9.1f }
        };

        var result = movies
            .Where(m => m.Id % 2 != 0 && m.Description != "boring")
            .OrderByDescending(m => m.Rating);

        foreach (var movie in result) {
            Console.WriteLine($"Id: {movie.Id}, Movie: {movie.Name}, Description: {movie.Description}, Rating: {movie.Rating}");
        }
    }
}

def merge_sort(arr):
    if len(arr) > 1:
        mid = len(arr) // 2
        L = arr[:mid]
        R = arr[mid:]

        merge_sort(L)
        merge_sort(R)

        i = j = k = 0
        while i < len(L) and j < len(R):
            if L[i] < R[j]:
                arr[k] = L[i]
                i += 1
            else:
                arr[k] = R[j]
                j += 1
            k += 1

        while i < len(L):
            arr[k] = L[i]
            i += 1
            k += 1

        while j < len(R):
            arr[k] = R[j]
            j += 1
            k += 1

arr = [12, 11, 13, 5, 6, 7]
print("Given array:", arr)
merge_sort(arr)
print("Sorted array:", arr)

#include <stdio.h>

void merge(int arr[], int left, int mid, int right) {
    int n1 = mid - left + 1;
    int n2 = right - mid;

    int L[n1], R[n2];

    for (int i = 0; i < n1; i++)
        L[i] = arr[left + i];
    for (int j = 0; j < n2; j++)
        R[j] = arr[mid + 1 + j];

    int i = 0, j = 0, k = left;
    while (i < n1 && j < n2) {
        if (L[i] <= R[j]) {
            arr[k] = L[i];
            i++;
        } else {
            arr[k] = R[j];
            j++;
        }
        k++;
    }

    while (i < n1) {
        arr[k] = L[i];
        i++;
        k++;
    }

    while (j < n2) {
        arr[k] = R[j];
        j++;
        k++;
    }
}

void mergeSort(int arr[], int left, int right) {
    if (left < right) {
        int mid = left + (right - left) / 2;

        mergeSort(arr, left, mid);
        mergeSort(arr, mid + 1, right);

        merge(arr, left, mid, right);
    }
}

void printArray(int arr[], int size) {
    for (int i = 0; i < size; i++)
        printf("%d ", arr[i]);
    printf("\n");
}

int main() {
    int arr[] = {12, 11, 13, 5, 6, 7};
    int arr_size = sizeof(arr) / sizeof(arr[0]);

    printf("Given array is \n");
    printArray(arr, arr_size);

    mergeSort(arr, 0, arr_size - 1);

    printf("Sorted array is \n");
    printArray(arr, arr_size);
    return 0;
}

public class FiboTabulation {
    public static int fibonacci(int n) {
        if (n <= 1) return n;
        int[] fib = new int[n + 1];
        fib[0] = 0;
        fib[1] = 1;

        for (int i = 2; i <= n; i++) {
            fib[i] = fib[i - 1] + fib[i - 2];
        }
        return fib[n];
    }

    public static void main(String[] args) {
        System.out.println(fibonacci(9)); // Output: 34
    }
}

function fibonacci(n) {
    let fib = Array(n + 1).fill(0);
    fib[1] = 1;

    for (let i = 2; i <= n; i++) {
        fib[i] = fib[i - 1] + fib[i - 2];
    }
    return fib[n];
}

console.log(fibonacci(9)); // Output: 34

# Write your MySQL query statement below
SELECT *
FROM Cinema
WHERE description != 'boring' AND id & 1 = 1
ORDER BY 4 DESC;