Recent programs

assignment1

an anonymous user · September 26, 2022 · SQL
create table customer
(
customerid varchar(10)primary key,
customername varchar2(20)not null,
mobileno number(10)not null,
gender varchar2(7)not null,
age number(3)not null,
location varchar2(30)not null,
doj date not null
);

TABLA_84

an anonymous user · September 26, 2022 · SQL
CREATE TABLE IF_SIB_CATALOGO_84 
(
    CODIGO	varchar(50) PRIMARY KEY,
    DESCRIPCION	varchar(300)
);

INSERT INTO IF_SIB_CATALOGO_84 (CODIGO, DESCRIPCION) VALUES ("11", "FIJO PAGADERO EN EFECTIVO");
INSERT INTO IF_SIB_CATALOGO_84 (CODIGO, DESCRIPCION) VALUES ("12", "FIJO PAGADERO CON OTRO TÍTULO VALOR");
INSERT INTO IF_SIB_CATALOGO_84 (CODIGO, DESCRIPCION) VALUES ("13", "FIJO PAGADERO EN EFECTIVO INDEXADO A MONEDA EXTRANJERA");
INSERT INTO IF_SIB_CATALOGO_84 (CODIGO, DESCRIPCION) VAL

queries and subqueries

an anonymous user · September 26, 2022 · MySQL
--select max(salary) from table_name
--select e-name from emp where salary= (select max(salary) from emp);
--select e-name from emp where salary = (select max(salary) from emp where salary <> (select max(salary) from emp));

--select dept,count(*) from emp groupby dept;
--select dept from emp groupby dept having count(*)<2;
--select e_name from emp where dept in (select dept from emp groupby dept having count(*)<2)

--select e_name from emp where salary in (select dept,max(salary) from emp grou
# JH
# This is a vector X:
X <- c(12, 16, 25, 13)
# X

X <- c( rep(80, 20), rep(110, 40), rep(170, 30), rep(220, 10) )
# X

N <- length(X)
N
sum(X)/N

TABLA_83

an anonymous user · September 26, 2022 · SQL
CREATE TABLE IF_SIB_CATALOGO_83 
(
    CODIGO	varchar(300) PRIMARY KEY,
    DESCRIPCION	varchar(300)
);

INSERT INTO IF_SIB_CATALOGO_83 (CODIGO, DESCRIPCION) VALUES ("11", "BANCO CENTRAL RD");
INSERT INTO IF_SIB_CATALOGO_83 (CODIGO, DESCRIPCION) VALUES ("12", "OTRAS ENTIDADES FINANCIERAS PÚBLICAS RD");
INSERT INTO IF_SIB_CATALOGO_83 (CODIGO, DESCRIPCION) VALUES ("21", "GOBIERNO CENTRAL RD");
INSERT INTO IF_SIB_CATALOGO_83 (CODIGO, DESCRIPCION) VALUES ("22", "MUNICIPIOS RD");
INSERT IN

summationrow

an anonymous user · September 26, 2022 · TypeScript
var book_data = [{
        BranchName: 'Deeksha, Thanisandra, Bengaluru',
        Uniform: 2,
        Shoes: 1,
        Accessories: 1,
        Books: 5,
      },
      {
        BranchName: 'Deeksha, Thanisandra, Bengaluru',
        Uniform: 2,
        Shoes: 3,

boj_18870_recursion

sungwoopark95 · September 26, 2022 · C++
#include <iostream>
#include <algorithm>
#include <map>
using namespace std;

int N;
int arrcpy[1000003];
int arr[1000003];
map<int, int> isused;

int search(int* arr, int start, int end, int target) {

summationrow

an anonymous user · September 26, 2022 · TypeScript
var book_data = [{
        BranchName: 'Deeksha, Thanisandra, Bengaluru',
        Uniform: 2,
        Shoes: 1,
        Accessories: 1,
        Books: 5,
      },
      {
        BranchName: 'Deeksha, Thanisandra, Bengaluru',
        Uniform: 2,
        Shoes: 3,

summationrow

an anonymous user · September 26, 2022 · TypeScript
var book_data = [{
        BranchName: 'Deeksha, Thanisandra, Bengaluru',
        Uniform: 2,
        Shoes: 1,
        Accessories: 1,
        Books: 5,
      },
      {
        BranchName: 'Deeksha, Thanisandra, Bengaluru',
        Uniform: 2,
        Shoes: 3,

summationrow

an anonymous user · September 26, 2022 · TypeScript
var book_data = [{
        BranchName: 'Deeksha, Thanisandra, Bengaluru',
        Uniform: 2,
        Shoes: 1,
        Accessories: 1,
        Books: 5,
      },
      {
        BranchName: 'Deeksha, Thanisandra, Bengaluru',
        Uniform: 2,
        Shoes: 3,

summationrow

an anonymous user · September 26, 2022 · TypeScript
var book_data = [{
        BranchName: 'Deeksha, Thanisandra, Bengaluru',
        Uniform: 2,
        Shoes: 1,
        Accessories: 1,
        Books: 5,
      },
      {
        BranchName: 'Deeksha, Thanisandra, Bengaluru',
        Uniform: 2,
        Shoes: 3,

Hema

an anonymous user · September 26, 2022 · SQL
create database hema
use hema
create table student(regno varchar(10) not null primary key , name varchar(30), DOB date, address varchar(50), phno bigint not null check(10<phno), bloodgrp varchar(5))
insert into student values('801', 'priya', '31/08/98', 'chennai', '5678905321', 'O+')
insert into student values('802', 'vikram', '15/09/97', 'madurai', '8765432190', 'B+')
insert into student values('803', 'ram', '18/07/95', 'coimbatore', '5678904321', 'AB+')
insert into student values('804', 'sham

table.sql

an anonymous user · September 26, 2022 · SQL
create table employee_tb2
(
  EmpId int private key,
  FirstName varchar(40),
  LastName varchar(40),
  DeptName varchar(15),
  salary float,
  phoneNo varchar(15)
  );
  
  insert into employee_tb2 values(101,'Avi','Yadav','HR',150000,'225500');

Hema

an anonymous user · September 26, 2022 · SQL
create database hema
use hema
create table student(regno varchar(10) not null primary key , name varchar(30), DOB date, address varchar(50), phno bigint not null check(10<phno), bloodgrp varchar(5))
insert into student values('801', 'priya', '31/08/98', 'chennai', '5678905321', 'O+')
insert into student values('802', 'vikram', '15/09/97', 'madurai', '8765432190', 'B+')
insert into student values('803', 'ram', '18/07/95', 'coimbatore', '5678904321', 'AB+')
insert into student values('804', 'sham

Hema

an anonymous user · September 26, 2022 · SQL
create database hema
use hema
create table student(regno varchar(10) not null primary key , name varchar(30), DOB date, address varchar(50), phno bigint not null check(10<phno), bloodgrp varchar(5))
insert into student values('801', 'priya', '31/08/98', 'chennai', '5678905321', 'O+')
insert into student values('802', 'vikram', '15/09/97', 'madurai', '8765432190', 'B+')
insert into student values('803', 'ram', '18/07/95', 'coimbatore', '5678904321', 'AB+')
insert into student values('804', 'sham

10798_SQL

an anonymous user · September 26, 2022 · SQL
-- create a table
CREATE TABLE users(
    name VARCHAR(128),
    email VARCHAR(128));
    
INSERT INTO users(email, name) VALUES ('email@maria.br', 'Maria');
INSERT INTO users(email, name) VALUES ('email@nuno.br', 'nuno');
INSERT INTO users(email,name ) VALUES ('JP@JP.pt', 'Pedro');
INSERT INTO users(email, name) VALUES ('email@maria.br', 'Maria');
INSERT INTO users(email, name) VALUES ('email@nuno.br', 'nuno');
INSERT INTO users(email,name ) VALUES ('JP@JP.pt', 'Gustavo');

Hema

an anonymous user · September 26, 2022 · SQL
create database hema
use hema
create table student(regno varchar(10) not null primary key , name varchar(30), DOB date, address varchar(50), phno bigint not null check(10<phno), bloodgrp varchar(5))
insert into student values('801', 'priya', '31/08/98', 'chennai', '5678905321', 'O+')
insert into student values('802', 'vikram', '15/09/97', 'madurai', '8765432190', 'B+')
insert into student values('803', 'ram', '18/07/95', 'coimbatore', '5678904321', 'AB+')
insert into student values('804', 'sham

Hema

an anonymous user · September 26, 2022 · SQL
create database hema
use hema
create table student(regno varchar(10) not null primary key , name varchar(30), DOB date, address varchar(50), phno bigint not null check(10<phno), bloodgrp varchar(5))
insert into student values('801', 'priya', '31/08/98', 'chennai', '5678905321', 'O+')
insert into student values('802', 'vikram', '15/09/97', 'madurai', '8765432190', 'B+')
insert into student values('803', 'ram', '18/07/95', 'coimbatore', '5678904321', 'AB+')
insert into student values('804', 'sham

1

an anonymous user · September 26, 2022 · Python
class Exponentiation():
    def __init__(self):
        self.number = 0
        self.degree = 0
    def read(self):
        self.number = float(input())
        self.degree = float(input())
        if self.number<0 or self.degree<0:
            print("Введено отрицательное число")
        return
    

TABLA_82

an anonymous user · September 26, 2022 · SQL
CREATE TABLE IF_SIB_CATALOGO_82 
(
    CODIGO	varchar(50) PRIMARY KEY,
    ESCALA	varchar(300)
);

INSERT INTO IF_SIB_CATALOGO_82 (CODIGO, ESCALA, , ) VALUES ("5", "Cuentas Activas Balance 0.00")
INSERT INTO IF_SIB_CATALOGO_82 (CODIGO, ESCALA, , ) VALUES ("10", "0.01", "-", "500")
INSERT INTO IF_SIB_CATALOGO_82 (CODIGO, ESCALA, , ) VALUES ("13", "500.01", "-", "1,000.00");
INSERT INTO IF_SIB_CATALOGO_82 (CODIGO, ESCALA, , ) VALUES ("16", "1,000.01", "-", "1,500.00");
INSERT INTO IF_SI