@subhamsingh

create table staff(
name varchar(10),
id varchar(5) primary key,
department varchar(15),
salary numeric (8),
location varchar(16)
);


insert into staff values('Amit', 'S1' ,'Sales', 20000 ,'KOL');

create table emp (
empno numeric(20) primary key,
ename varchar(20) not null,
job varchar(30),
mgr numeric(5),
hiredate varchar(15),
sal numeric(6),
comm numeric(5),
deptno numeric(3)
);

def comp(a,b):
if a = = b:
    return true 
    return false 
    
    x= int(input("Enter the 1 st n.o"))
    x= int(input("Enter the 2 nd n.o"))
    
    result =  comp(x,y)

create table staff(
name varchar(20),
id varchar(10) not null,
department varchar,
salary numeric(10),
loction varchar(30)

);

insert  into staff values('Amit', 'S1', 'Sales', '20000' ,'KOL');

create table personal(
 name varchar(10),
 roll numeric(10) not null,
 address varchar(20),
 score numeric(20)
);

insert into personal values( 'AYAN' , 1 ,'KOL', 1234);
insert into personal values('NIKHIL', 2, 'KOL', 2134);
insert into personal values('RAMU', 3, 'DEL', 4321 );

create table personal(
 name varchar(10),
 roll numeric(10) not null,
 address varchar(20),
 score numeric(20)
);

insert into personal values( 'AYAN' , 1 ,'KOL', 1234);
insert into personal values('NIKHIL', 2, 'KOL', 2134);
insert into personal values('RAMU', 3, 'DEL', 4321 );

CREATE TABLE EMP (
  EMPNO NUMERIC(4) PRIMARY KEY,
  ENAME VARCHAR(20) NOT NULL,
  JOB CHAR(10) NOT NULL,
  MGR NUMERIC(4),
  HIREDATE DATETIME,
  SAL NUMERIC(9,2),
  COMM NUMERIC(7,2),
  DEPTNO NUMERIC(2)
);

CREATE TABLE EMP (
  EMPNO NUMERIC(4) PRIMARY KEY,
  ENAME VARCHAR(20) NOT NULL,
  JOB CHAR(10) NOT NULL,
  MGR NUMERIC(4),
  HIREDATE DATETIME,
  SAL NUMERIC(9,2),
  COMM NUMERIC(7,2),
  DEPTNO NUMERIC(2)
);

Fahrenheit= float(input("Enter for conversion"))

Celsius = ((Fahrenheit-32)*5)/9  
print("Temperature in Celsius is: ");  
print(Celsius);  

x = 5
y = 2

sum = x + y
average = sum / 2
print(f'Average = {average}')

num = 89

oneplace = num%10

print("the digit at one in place",oneplace)

print("Enter the Radius of Circle: ")
r = float(input())
a = 3*3.14*r*r
print("\nArea = ", a)

# Store input numbers:  
num1 = input('Enter first number: ')  
num2 = input('Enter second number: ')  
  
# Add two numbers  
sum = float(num1) + float(num2)  
# Subtract two numbers  
min = float(num1) - float(num2)  
# Multiply two numbers  
mul = float(num1) * float(num2)  

# Python Program to Calculate Distance 

# Reading co-ordinates
x1 = float(input('Enter x1: '))
y1 = float(input('Enter y1: '))
x2 = float(input('Enter x2: '))
y2 = float(input('Enter y2: '))

# Calculating distance
d = ( (x2-x1)**2 + (y2-y1)**2 ) ** 0.5

# Python Program to find the area of triangle

a = 5
b = 6
c = 7

# Uncomment below to take inputs from the user
# a = float(input('Enter first side: '))
# b = float(input('Enter second side: '))
# c = float(input('Enter third side: '))

num1 = 5
print(num1, 'is of type', type(num1))

num2 = 2.0
print(num2, 'is of type', type(num2))

num3 = 1+2j
print(num3, 'is of type', type(num3))

# Python program to convert decimal into other number systems
dec = 344

print("The decimal value of", dec, "is:")
print(bin(dec), "in binary.")
print(oct(dec), "in octal.")
print(hex(dec), "in hexadecimal.")

val="Hello"
print(val)
val=100
print(val)
val=12.34
print(val)

val="Hello"
print(val)
val=100
print(val)
val=12.34
print(val)

val="Hello"
print(val)
val=100
print(val)
val=12.34
print(val)