Giter Club home page Giter Club logo

Aman Pandit's Projects

extract-data icon extract-data

Two PostgreSQL SQL queries are available in this repository that may be used to retrieve information from a database in this case a students database.

factor-finder icon factor-finder

This script determines the factors of two positive whole integer.

file-reader icon file-reader

This Python script reads a file and displays its contents on the console. The script uses the 'pathlib' module to create a Path object that points to the file to be read.

filtered-student-information icon filtered-student-information

This SQL query returns the last name, first name, student ID, and class ID of students with the first name 'Thomas' who are enrolled in 'COMPSCI101'. It filters results based on these conditions using a WHERE clause.

finding-unique-values-in-a-postgresql-database icon finding-unique-values-in-a-postgresql-database

A PostgreSQL query that utilizes the DISTINCT keyword to retrieve a list of unique values associated with a specific column in a table named 'students'.Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.

hex-array icon hex-array

This straightforward Python script creates a hexagonal tessellated design.

high-noon-hero icon high-noon-hero

"High Noon Hero" is a Python game that tests the player's reflexes in a shooting competition. Once the word "SHOOT" appears, the player must hit Enter within a certain time window, and their speed is measured for each try.

hourglass icon hourglass

This Python application mimics the action of an hourglass.

id-basedfiltering icon id-basedfiltering

The ID-Based Filtering PostgreSQL query returns all columns from a table for a specified value.

leetspeak icon leetspeak

LeetSpeak is a Python program for translating English messages into leetspeak.

madlibsgen icon madlibsgen

This is a simple Python script that generates a story by prompting the user to provide several input values. The generated story will contain the user-provided inputs.

maze-mayhem icon maze-mayhem

In the straightforward text-based game Maze Mayhem, the player must make their way through a maze populated by robots.

morsemap icon morsemap

This is a Python script that can convert text to Morse code and vice versa using a dictionary containing the Morse code equivalent of each letter.

nameconcatenation icon nameconcatenation

Overall, the NameConcatenation query combines the values of two distinct columns into a single column, which is designated as "Fullname" using the "AS" keyword as an alias, providing a succinct and effective method to get and display the complete names of students in a PostgreSQL database. 

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.