1080. Graduate Admission (30)解题报告

#define _CRT_SECURE_NO_WARNINGS
#include <cstdio>
#include <cstdlib>
#include <algorithm>
#include <vector>
using namespace std;

const int K = 5;
struct student {
    int no, rank, ge, gi, app[K];
};
struct school {
    int q;
    vector<int> v;
};

int comp(const void *v1, const void *v2) {
    int flag;
    student s1, s2;
    s1 = *((student *)v1);
    s2 = *((student *)v2);
    if (s1.ge + s1.gi > s2.ge + s2.gi) {
        flag = -1;
    }
    else if (s1.ge + s1.gi < s2.ge + s2.gi) {
        flag = 1;
    }
    else {
        if (s1.ge > s2.ge) {
            flag = -1;
        }
        else if (s1.ge < s2.ge) {
            flag = 1;
        }
        else {
            flag = 0;
        }
    }
    return flag;
}
bool cmp(student s1, student s2) {
    if (s1.rank == s2.rank) {
        return true;
    }
    else {
        return false;
    }
}

int main(void) {
    int n, m, k, i, j;
    student *st;
    school *sc;
    scanf("%d %d %d", &n, &m, &k);
    st = new student[n];
    sc = new school[m];
    for (i = 0; i < m; i++) {
        scanf("%d", &sc[i].q);
    }
    for (i = 0; i < n; i++) {
        st[i].no = i;
        scanf("%d %d", &st[i].ge, &st[i].gi);
        for (j = 0; j < k; j++) {
            scanf("%d", &st[i].app[j]);
        }
    }
    qsort(st, n, sizeof(student), comp);
    int rank = 0;
    st[0].rank = rank;
    for (i = 1; i < n; i++) {
        if (st[i].ge + st[i].gi < st[i - 1].ge + st[i - 1].gi) {
            rank++;
            st[i].rank = rank;
        }
        else if (st[i].ge < st[i - 1].ge) {
            rank++;
            st[i].rank = rank;
        }
        else {
            st[i].rank = rank;
        }
    }
    for (i = 0; i < n; i++) {
        for (j = 0; j < k; j++) {
            if (sc[st[i].app[j]].v.size() > 0 && cmp(st[i], st[sc[st[i].app[j]].v.back()])) {
                sc[st[i].app[j]].v.push_back(i);
                break;
            }
            else if (sc[st[i].app[j]].v.size() < sc[st[i].app[j]].q) {
                sc[st[i].app[j]].v.push_back(i);
                break;
            }
        }
    }
    for (i = 0; i < m; i++) {
        if (sc[i].v.size()) {
            for (j = 0; j < sc[i].v.size(); j++) {
                sc[i].v[j] = st[sc[i].v[j]].no;
            }
            sort(sc[i].v.begin(), sc[i].v.end());
            printf("%d", sc[i].v[0]);
            for (j = 1; j < sc[i].v.size(); j++) {
                printf(" %d", sc[i].v[j]);
            }
        }
        putchar('\n');
    }
    return 0;
}
select * from ( SELECT P.PATIENT_ID, P.VISIT_ID, PM.NAME, PM.SEX, P.ADMISSION_DATE_TIME, ( SELECT TOP 1 DP.DEPT_NAME FROM DEPT_DICT DP WHERE DP.DEPT_CODE = P.DEPT_ADMISSION_TO ) AS DEPT_ADM, P.DISCHARGE_DATE_TIME, ( SELECT TOP 1 DP.DEPT_NAME FROM DEPT_DICT DP WHERE DP.DEPT_CODE = P.DEPT_DISCHARGE_FROM ) AS DEPT_DIS, DATEDIFF( DAY, P.ADMISSION_DATE_TIME, P.DISCHARGE_DATE_TIME ) AS INPAT_DAYS, P.DOCTOR_IN_CHARGE --datediff(day, P.ADMISSION_DATE_TIME,P.DISCHARGE_DATE_TIME) as zyts FROM PAT_VISIT P INNER JOIN PAT_MASTER_INDEX PM ON PM.PATIENT_ID = P.PATIENT_ID WHERE select * from ( SELECT P.PATIENT_ID, P.VISIT_ID, PM.NAME, PM.SEX, P.ADMISSION_DATE_TIME, ( SELECT TOP 1 DP.DEPT_NAME FROM DEPT_DICT DP WHERE DP.DEPT_CODE = P.DEPT_ADMISSION_TO ) AS DEPT_ADM, P.DISCHARGE_DATE_TIME, ( SELECT TOP 1 DP.DEPT_NAME FROM DEPT_DICT DP WHERE DP.DEPT_CODE = P.DEPT_DISCHARGE_FROM ) AS DEPT_DIS, DATEDIFF( DAY, P.ADMISSION_DATE_TIME, P.DISCHARGE_DATE_TIME ) AS INPAT_DAYS, P.DOCTOR_IN_CHARGE --datediff(day, P.ADMISSION_DATE_TIME,P.DISCHARGE_DATE_TIME) as zyts FROM PAT_VISIT P INNER JOIN PAT_MASTER_INDEX PM ON PM.PATIENT_ID = P.PATIENT_ID WHERE P.DISCHARGE_DATE_TIME >= '2016-01-01' AND P.DISCHARGE_DATE_TIME < = '2023-07-10' AND DATEDIFF( DAY,P.ADMISSION_DATE_TIME, P.DISCHARGE_DATE_TIME ) >= 30 ) t order by inpat_days desc P.DISCHARGE_DATE_TIME >= '2016-01-01' AND P.DISCHARGE_DATE_TIME < = '2023-07-10' AND DATEDIFF( DAY,P.ADMISSION_DATE_TIME, P.DISCHARGE_DATE_TIME ) >= 30 ) t order by inpat_days desc 帮我把这段sql优化一下
最新发布
07-25
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值