Recent programs

prog

an anonymous user · December 06, 2021 · Java
import java.util.*;
import java.lang.*;
import java.io.*;

// The main method must be in a class named "Main".
class Main {
    public static void main(String[] args) {
        Scanner sc = new Scanner( System.in);
        // int n = sc.nextInt();
        String s = sc.nextLine().trim();
        

sqL

an anonymous user · December 06, 2021 · SQL
CREATE TABLE customer_master(
CUSTOMER_NUMBER VARCHAR(6),
FIRSTNAME VARCHAR(30),
middlename VARCHAR(30),
lastname VARCHAR(30),
CUSTOMER_CITY VARCHAR(15),
CUSTOMER_CONTACT_NO VARCHAR(10),
occupation VARCHAR(10),
CUSTOMER_DATE_OF_BIRTH DATE,
CONSTRAINT customer_custid_pk PRIMARY KEY 
(CUSTOMER_NUMBER)); 

join operation

an anonymous user · December 06, 2021 · SQL
create table student(roll_no. int,name varchar(20),Address varchar(30),phone_no.,age int);
insert into student values(1,'Harsh','Delhi',98542134,18);
insert into student values(2,'Pratik','Bihari',98542135,19);
insert into student values(3,'Riyabka','Siliguri',7087653,20);
insert into student values(4,'Deep','Ramnagar',87696532,18);
insert into student values(5,'Saptarhi','Kolkata',6547896,19);

select * from student;

sql

an anonymous user · December 06, 2021 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';

smallest divisor

jaswanth · December 06, 2021 · C
#include <stdio.h>
#include <math.h>

int smallest_divisor(int n) {

	int i;
	for (i = 2; i <= sqrt(n); ++i) {
		if (n % i == 0) {
			return i;
		}
	}

Average number n

an anonymous user · December 06, 2021 · Bash
#!/bin/bash

echo "Enter Size(N)"
read N

i=1
sum=0

echo "Enter Numbers"
while [ $i -le $N ]
do

Join_Operation

an anonymous user · December 06, 2021 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';

Join_Operation

an anonymous user · December 06, 2021 · SQL
create table student(roll_no. int,name varchar(20),Address varchar(30),phone_no int,age int);

insert into student values(1,Harsh,Delhi,3465,18);
insert into student values(2,Prateek,Bihar,22334,19);
insert into student values(3,Riyanka,ciliguri,3454,20);
insert into student values(4,Deep,Kolkata,7865,18);
insert into student values(5,Rohit,Alipur,2094,18);

select * from student;

join operation

an anonymous user · December 06, 2021 · SQL
create table student(roll_no. int,name varchar(20),Address varchar(30),phone_no.,age int);
insert into student values(1,Harsh,Delhi,98542134,18);
insert into student values(2,Pratik,Bihari,98542135,19);
insert into student values(3,Riyabka,Siliguri,7087653,20);
insert into student values(4,Deep,Ramnagar,87696532,18);
insert into student values(5,Saptarhi,Kolkata,6547896,19);

select * from student;

FAYYYY

an anonymous user · December 06, 2021 · SQL
-- create a table
CREATE TABLE Employee (
  SSN int not null ,
  Ename varchar ,
  Age int,
  Salary int,
  primary key (SSN)
);
CREATE TABLE Department (
  DEPID int not null ,
  Dname varchar ,

JehDatabase

an anonymous user · December 06, 2021 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';

m

an anonymous user · December 06, 2021 · SQL
-- create a table
CREATE TABLE EMPLOYEE (
SSN    int,
ENAME  varchar,
AGE    int,
SALARY int,
primary key (SSN));
-- select *from EMPLOYEE;

CREATE TABLE DEPARTMENT(
DEPID  int(1),

razan

an anonymous user · December 06, 2021 · SQL
CREATE TABLE EMPLPYEE (
ssn   int,
ename  varchar,
age   int,
salary  ,
primary key(ssn));
-- select*from EMPLPYEE;

CREATE TABLE department (
depid  int(1),

New SQL SHEET

an anonymous user · December 06, 2021 · SQL
-- create a table
create table employee(id integer, ename varchar(100), empno integer, job varchar(100), mgr integer, hiredate date, sal integer, comm integer, deptno integer);
insert into employee(id, ename, empno, job, mgr, hiredate, sal, comm, deptno) values(1, "SMITH", "7369", "CLERK", "7902", "1980/11/20", "800.01", "900", "20");
insert into employee(id, ename, empno, job, mgr, hiredate, sal, comm, deptno) values(2, "ALLEN", "7339", "MANAGER", "7698", "1980/12/22", "1600.07", "1200", "20")

lab1_complelete

an anonymous user · December 06, 2021 · Assembly
%macro scall 4
mov rax,%1
mov rdi,%2
mov rsi,%3
mov rdx,%4
syscall
%endmacro

section .data
menu db 10d,13d, "          MENU"
db 10d,"1. Enter the string"

قواعد اخر تمرين

an anonymous user · December 06, 2021 · SQL
-- create a table
CREATE TABLE employee (
 SSN INTEGER ,
  ENAME  varcharacter not null,
  AGE  int(2) ,
  SALARY INT ,
  primary key (SSN));
CREATE TABLE DEPARTMENT( 
DEPID INT ,
DNAME varcharacter NOT NULL,
MGRSSN INT ,

SQL T6

an anonymous user · December 06, 2021 · SQL
-- create a table
CREATE TABLE EMPLOYEE (
SSN integer unique,
ENAME varchar,
AGE integer,
SALARY integer,
primary key (SSN));

CREATE TABLE DEPARTMENT( 
DEPID integer unique,
DNAME varchar,

Calculator_Alianza,AldwinMiguelA.

an anonymous user · December 06, 2021 · Python
print("Simple Calculator")
a = float(input("Enter first number: "))
b = input("Enter operator: ")
c = float(input("Enter second number: "))

if b == "+":
    print(a + c)

elif b == "-":
    print(a - c)

Fib 2

an anonymous user · December 06, 2021 · Fortran
program fibo
implicit none
integer::x,y,z,n=0,c
print*,'enter N'
read*,c !user enter the value of N=? ( the value stored in 'c')
      z=0
      y=1
print  "(i10)"  ,z,y!the program cosmetically prints the two initial values
1 x=y+z
print "(i10)",x ! the program prints the rest of the values using line 13

MADAWEY ALKHRAAN

an anonymous user · December 06, 2021 · SQL
-- create a table
CREATE TABLE EMPLOYEE (
SSN int (9)  ,
ENAME varchar ,
Age int ,
SALARY int , 
primary key (SSN));
CREATE TABLE DEPARTMENT (
DEPID int (1),
DNAME varchar ,
MGRSSN int (9),